SSF_GRPO_BIND

(SQL View)
Index Back

Group Line Corp Bind

Bind record for the Group Line Population Selection Process for Corp transactions.

SELECT EXT_ORG_ID FROM PS_EXT_ORG_TBL A WHERE A.EFFDT = ( SELECT MAX(Y.EFFDT) FROM PS_EXT_ORG_TBL Y WHERE Y.EXT_ORG_ID = A.EXT_ORG_ID AND Y.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID