View: PAY_JP_SI_FD_ACTION_DATE_V

Product:	PAY - Payroll
Description:	This view returns Assignment Action of Bonus or Santei or Geppen Payroll Process based on business_group_id and element_set_code.
Implementation/DBA Data:	APPS.PAY_JP_SI_FD_ACTION_DATE_V

View Text

SELECT /*+ ORDERED INDEX(PPA PAY_PAYROLL_ACTIONS_FK6) */ PBG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PES.ELEMENT_SET_NAME ELEMENT_SET_CODE
, PPA.ELEMENT_SET_ID ELEMENT_SET_ID
, PPA.DATE_EARNED DATE_EARNED
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.ACTION_STATUS ACTION_STATUS
, PPA.PAYROLL_ID PAYROLL_ID
, PPA.ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, PPA.REQUEST_ID REQUEST_ID
, PPA.LEGISLATIVE_PARAMETERS LEGISLATIVE_PARAMETERS
, 'Y' DEFAULT_VALUE_FLAG
FROM PER_BUSINESS_GROUPS PBG
, PAY_ELEMENT_SETS PES
, PAY_PAYROLL_ACTIONS PPA
WHERE PES.ELEMENT_SET_NAME IN ('SAN'
, 'GEP'
, 'BON')
AND NVL(PES.BUSINESS_GROUP_ID
, PBG.BUSINESS_GROUP_ID) = PBG.BUSINESS_GROUP_ID
AND NVL(PES.LEGISLATION_CODE
, PBG.LEGISLATION_CODE) = PBG.LEGISLATION_CODE /* PAY_PAYROLL_ACTIONS_FK1 DOES NOT WORK AS AND-EQUAL INDEX */
AND PPA.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID
AND PPA.ELEMENT_SET_ID = PES.ELEMENT_SET_ID UNION SELECT /*+ ORDERED */ PBG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TO_NUMBER(NULL) PAYROLL_ACTION_ID
, PES.ELEMENT_SET_NAME ELEMENT_SET_CODE
, TO_NUMBER(NULL) ELEMENT_SET_ID
, FS.EFFECTIVE_DATE DATE_EARNED
, FS.EFFECTIVE_DATE EFFECTIVE_DATE
, NULL ACTION_STATUS
, TO_NUMBER(NULL) PAYROLL_ID
, TO_NUMBER(NULL) ASSIGNMENT_SET_ID
, TO_NUMBER(NULL) REQUEST_ID
, NULL LEGISLATIVE_PARAMETERS
, 'N' DEFAULT_VALUE_FLAG
FROM FND_SESSIONS FS
, PAY_ELEMENT_SETS PES
, PER_BUSINESS_GROUPS PBG
WHERE PES.ELEMENT_SET_NAME IN ('SAN'
, 'GEP'
, 'BON') /* INCLUDE CASE WHEN LEGISLATION CODE OF BUSINESS GROUP IS NOT JP */
AND PES.LEGISLATION_CODE = 'JP'
AND FS.SESSION_ID = USERENV('SESSIONID')

Columns