View: PAY_PAYROLL_ACTIONS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYROLL_ACTIONS_V

View Text

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 (+)

Columns