eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_PAYROLL_ACTIONS_V

Source

View Text - Preformatted


SELECT PAC1.ROWID ROW_ID , PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , PAC1.PAYROLL_ID , PAC1.PAYROLL_ACTION_ID , PAC1.ACTION_TYPE , PAC1.EFFECTIVE_DATE , /* "DATE" */ HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME , /* "PERIOD" */ LO1.MEANING , /* "TYPE" */ PRO.PAYROLL_NAME , /* "PAYROLL"*/ DECODE(PAC1.ACTION_STATUS, 'P',DECODE( REQUEST.PHASE_CODE,'C','E',PAC1.ACTION_STATUS), PAC1.ACTION_STATUS ) STATUS_CODE , PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS(PAC1.PAYROLL_ACTION_ID, PAC1.ACTION_STATUS, PAC1.REQUEST_ID ) ACTION_STATUS , PAC1.ACTION_SEQUENCE , PAC1.DISPLAY_RUN_NUMBER , PAC1.CONSOLIDATION_SET_ID , PAC1.ASSIGNMENT_SET_ID , PAC1.ELEMENT_SET_ID , PAC1.REQUEST_ID , PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST(PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST , PAY_PAYROLL_ACTIONS_PKG.V_NAME(PAC1.PAYROLL_ACTION_ID, PAC1.ACTION_TYPE, PAC1.CONSOLIDATION_SET_ID, PAC1.DISPLAY_RUN_NUMBER, PAC1.ELEMENT_SET_ID, PAC1.ASSIGNMENT_SET_ID, PAC1.EFFECTIVE_DATE) NAME , PAC1.COMMENTS , PAC1.DATE_EARNED FROM FND_CONCURRENT_REQUESTS REQUEST, HR_LOOKUPS LO1, PAY_PAYROLLS_F PRO, PAY_PAYROLL_ACTIONS PAC1 WHERE /***************************/ /* ACTION TYPE DESCRIPTION */ /***************************/ LO1.LOOKUP_TYPE = 'ACTION_TYPE' AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE /****************/ /* PAYROLL NAME */ /****************/ AND PAC1.PAYROLL_ID = PRO.PAYROLL_ID AND ( PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE AND PRO.EFFECTIVE_END_DATE ) AND PAC1.ACTION_STATUS != 'U' AND PAC1.ACTION_TYPE != 'I' AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+) UNION ALL SELECT PAC1.ROWID ROW_ID, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID, PAC1.PAYROLL_ID, PAC1.PAYROLL_ACTION_ID, PAC1.ACTION_TYPE, PAC1.EFFECTIVE_DATE , /* "DATE" */ NULL , LO1.MEANING , /* "TYPE" */ NULL , DECODE(PAC1.ACTION_STATUS, 'P',DECODE( REQUEST.PHASE_CODE,'C','E',PAC1.ACTION_STATUS), PAC1.ACTION_STATUS ) STATUS_CODE, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS(PAC1.PAYROLL_ACTION_ID, PAC1.ACTION_STATUS, PAC1.REQUEST_ID) ACTION_STATUS, PAC1.ACTION_SEQUENCE , PAC1.DISPLAY_RUN_NUMBER, PAC1.CONSOLIDATION_SET_ID, PAC1.ASSIGNMENT_SET_ID, PAC1.ELEMENT_SET_ID, PAC1.REQUEST_ID, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST (PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST, PAY_PAYROLL_ACTIONS_PKG.V_NAME(PAC1.PAYROLL_ACTION_ID, PAC1.ACTION_TYPE, PAC1.CONSOLIDATION_SET_ID, PAC1.DISPLAY_RUN_NUMBER, PAC1.ELEMENT_SET_ID, PAC1.ASSIGNMENT_SET_ID, PAC1.EFFECTIVE_DATE) NAME, PAC1.COMMENTS, PAC1.DATE_EARNED FROM FND_CONCURRENT_REQUESTS REQUEST, HR_LOOKUPS LO1 , PAY_PAYROLL_ACTIONS PAC1 /*****************************************/ /* JUST PICK UP THE UNRESTRICTED ACTIONS */ /* I.E. THOSE NOT FOR A SPECIFIC PAYROLL */ /*****************************************/ WHERE PAC1.PAYROLL_ID IS NULL /***************************/ /* ACTION TYPE DESCRIPTION */ /***************************/ AND LO1.LOOKUP_TYPE = 'ACTION_TYPE' AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE AND PAC1.ACTION_STATUS != 'U' AND PAC1.ACTION_TYPE != 'I' AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+)

View Text - HTML Formatted

SELECT PAC1.ROWID ROW_ID
, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.EFFECTIVE_DATE
, /* "DATE" */ HR_PAYROLLS.DISPLAY_PERIOD_NAME(PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, /* "PERIOD" */ LO1.MEANING
, /* "TYPE" */ PRO.PAYROLL_NAME
, /* "PAYROLL"*/ DECODE(PAC1.ACTION_STATUS
, 'P'
, DECODE( REQUEST.PHASE_CODE
, 'C'
, 'E'
, PAC1.ACTION_STATUS)
, PAC1.ACTION_STATUS ) STATUS_CODE
, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS(PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_STATUS
, PAC1.REQUEST_ID ) ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.CONSOLIDATION_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.ELEMENT_SET_ID
, PAC1.REQUEST_ID
, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST(PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST
, PAY_PAYROLL_ACTIONS_PKG.V_NAME(PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.CONSOLIDATION_SET_ID
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.ELEMENT_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.EFFECTIVE_DATE) NAME
, PAC1.COMMENTS
, PAC1.DATE_EARNED
FROM FND_CONCURRENT_REQUESTS REQUEST
, HR_LOOKUPS LO1
, PAY_PAYROLLS_F PRO
, PAY_PAYROLL_ACTIONS PAC1
WHERE /***************************/ /* ACTION TYPE DESCRIPTION */ /***************************/ LO1.LOOKUP_TYPE = 'ACTION_TYPE'
AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE /****************/ /* PAYROLL NAME */ /****************/
AND PAC1.PAYROLL_ID = PRO.PAYROLL_ID
AND ( PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE
AND PRO.EFFECTIVE_END_DATE )
AND PAC1.ACTION_STATUS != 'U'
AND PAC1.ACTION_TYPE != 'I'
AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+) UNION ALL SELECT PAC1.ROWID ROW_ID
, PAC1.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.EFFECTIVE_DATE
, /* "DATE" */ NULL
, LO1.MEANING
, /* "TYPE" */ NULL
, DECODE(PAC1.ACTION_STATUS
, 'P'
, DECODE( REQUEST.PHASE_CODE
, 'C'
, 'E'
, PAC1.ACTION_STATUS)
, PAC1.ACTION_STATUS ) STATUS_CODE
, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS(PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_STATUS
, PAC1.REQUEST_ID) ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.CONSOLIDATION_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.ELEMENT_SET_ID
, PAC1.REQUEST_ID
, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST (PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST
, PAY_PAYROLL_ACTIONS_PKG.V_NAME(PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.CONSOLIDATION_SET_ID
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.ELEMENT_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.EFFECTIVE_DATE) NAME
, PAC1.COMMENTS
, PAC1.DATE_EARNED
FROM FND_CONCURRENT_REQUESTS REQUEST
, HR_LOOKUPS LO1
, PAY_PAYROLL_ACTIONS PAC1 /*****************************************/ /* JUST PICK UP THE UNRESTRICTED ACTIONS */ /* I.E. THOSE NOT FOR A SPECIFIC PAYROLL */ /*****************************************/
WHERE PAC1.PAYROLL_ID IS NULL /***************************/ /* ACTION TYPE DESCRIPTION */ /***************************/
AND LO1.LOOKUP_TYPE = 'ACTION_TYPE'
AND LO1.LOOKUP_CODE = PAC1.ACTION_TYPE
AND PAC1.ACTION_STATUS != 'U'
AND PAC1.ACTION_TYPE != 'I'
AND PAC1.REQUEST_ID = REQUEST.REQUEST_ID (+)