Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_FUNCTIONAL_USAGES_V |
SELECT PFU.ROWID ROW_ID
, PFU.USAGE_ID
, PFU.AREA_ID
, PFA.SHORT_NAME
, PFA.DESCRIPTION
, PFU.LEGISLATION_CODE
, DECODE(PFU.LEGISLATION_CODE
, '-1'
, '
, FT.TERRITORY_SHORT_NAME) "LEGISLATION_NAME"
, PFU.BUSINESS_GROUP_ID
, DECODE(PFU.BUSINESS_GROUP_ID
, -1
, '
, BG.NAME) "BUSINESS_GROUP_NAME"
, PFU.PAYROLL_ID
, DECODE(PFU.PAYROLL_ID
, -1
, '
, PAPF.PAYROLL_NAME) "PAYROLL_NAME"
, PFU.LAST_UPDATE_DATE
, PFU.LAST_UPDATED_BY
, PFU.LAST_UPDATE_LOGIN
, PFU.CREATED_BY
, PFU.CREATION_DATE
FROM PAY_ALL_PAYROLLS PAPF
, PER_BUSINESS_GROUPS BG
, FND_TERRITORIES_VL FT
, PAY_FUNCTIONAL_AREAS PFA
, PAY_FUNCTIONAL_USAGES PFU
WHERE PAPF.PAYROLL_ID (+)= PFU.PAYROLL_ID
AND BG.BUSINESS_GROUP_ID (+)= PFU.BUSINESS_GROUP_ID
AND FT.TERRITORY_CODE (+)= PFU.LEGISLATION_CODE
AND PFA.AREA_ID = PFU.AREA_ID