Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_OPT_D |
SELECT OPT.ROWID ROW_ID
, OPT.OPT_ID
, OPT.EFFECTIVE_START_DATE
, OPT.EFFECTIVE_END_DATE
, OPT.NAME
, CMBN_PTIP_OPT.NAME
, OPT.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, OPT.SHORT_NAME
, OPT.SHORT_CODE
, OPT.COMPONENT_REASON
, OPT.MAPPING_TABLE_NAME
, OPT.MAPPING_TABLE_PK_ID
, OPT.LEGISLATION_CODE
, OPT.LEGISLATION_SUBGROUP
FROM BEN_OPT_F OPT
, FND_USER FUSER
, BEN_CMBN_PTIP_OPT_F CMBN_PTIP_OPT
WHERE FUSER.USER_ID (+)= OPT.LAST_UPDATED_BY
AND CMBN_PTIP_OPT.CMBN_PTIP_OPT_ID (+)= OPT.CMBN_PTIP_OPT_ID