View: PAY_INDICATOR_ENTRIES_V

Product:	PAY - Payroll
Description:	View used in Advance Pay form: PAYWSAHP to retrieve indicator element entries for the assignment.
Implementation/DBA Data:	APPS.PAY_INDICATOR_ENTRIES_V

View Text

SELECT /*VIEW USED BY BLOCK ADVANCE IN ADVANCE PAY FORM
, PAYWSAHP
, TO RETRIEVE INDICATOR*/ /*ELEMENT ENTRIES FOR THE ASSIGNMENT. */ /*IT WILL SHOW ADVANCED PERIODS AS INDICATED BELOW: */ /* PAY PERIOD1 HOLIDAY PERIOD1 PAY PERIOD2 HOLIDAY PERIOD2 */ /* |-----------| |-----------------| |-----------| |-----------------| */ /* | */ /*SESSION DATE1 */ /* | */ /* SESSION DATE2 */ /* | */ /* SESSION DATE3 */ /* | */ /* SESSION DATE4 */ /* | */ /* SESSION DATE5 | */ /* SESSION DATE6 */ /*SESSION DATE1
, 2
, 3
, 4: SHOW PAY/HOLIDAY PERIOD1
AND 2 */ /*SESSION DATE5: SHOW PAY/HOLIDAY PERIOD2 */ /*SESSION DATE6: NO PERIODS SHOWN */ /* NOTE: THIS VIEW HANDLES EMPTY QUERIES ONLY DUE TO THE EXISTING */ /* TO_DATE STATEMENTS. THEREFORE THE CORRESPONDING FORM DOES */ /* NOT SUPPORT QBE. */ /*+ ORDERED */ DISTINCT /*LEGISLATION CODE.*/ PLR1.LEGISLATION_CODE
, /* ASSIGNMENT_ID.*/ PEEF.ASSIGNMENT_ID
, /* PAY ADVANCE INDICATOR ENTRY CONTEXT INFO.*/ PEEF.ELEMENT_ENTRY_ID
, PEEF.EFFECTIVE_START_DATE
, /* PAYMENT PERIOD END DATE.*/ PEEF.EFFECTIVE_END_DATE
, /* ADVANCE PAY START DATE.*/ FND_DATE.CANONICAL_TO_DATE(PEEVF1.SCREEN_ENTRY_VALUE)
, /* ADVANCE PAY END DATE.*/ FND_DATE.CANONICAL_TO_DATE(PEEVF2.SCREEN_ENTRY_VALUE)
, /* ADVANCED AMOUNT.*/ PAY_ADVANCE_PAY_PKG.ADVANCE_AMOUNT ( FND_DATE.CANONICAL_TO_DATE (PEEVF1.SCREEN_ENTRY_VALUE)
, PEEF.ELEMENT_ENTRY_ID
, PEEF.ASSIGNMENT_ID )
, /* PROCESSED FLAG.*/ DECODE(PAY_ADVANCE_PAY_PKG.ADVANCE_AMOUNT ( FND_DATE.CANONICAL_TO_DATE (PEEVF1.SCREEN_ENTRY_VALUE)
, PEEF.ELEMENT_ENTRY_ID
, PEEF.ASSIGNMENT_ID )
, NULL
, 'N'
, 'Y')
, /* CREATED BY.*/ PEEF.CREATED_BY
, /* CREATION DATE.*/ PEEF.CREATION_DATE
, /* LAST UPDATED BY.*/ PEEF.LAST_UPDATED_BY
, /* LAST UPDATE DATE.*/ PEEF.LAST_UPDATE_DATE
, /* LAST UPDATE LOGIN.*/ PEEF.LAST_UPDATE_LOGIN
, /* ROW ID.*/ PEEF.ROWID
FROM PAY_LEGISLATION_RULES PLR1
, PAY_LEGISLATION_RULES PLR2
, PER_ASSIGNMENTS_F PAF
, PAY_ELEMENT_ENTRIES_F PEEF
, PAY_ELEMENT_ENTRY_VALUES_F PEEVF1
, PAY_INPUT_VALUES_F PIVF1
, PAY_INPUT_VALUES_F PIVF2
, FND_SESSIONS FS
, PAY_ELEMENT_ENTRY_VALUES_F PEEVF2
WHERE /* INCLUDES FIXES: 634019*/ /* LEGISLATION: */ PLR1.RULE_TYPE = 'PAI_START_DATE'
AND PLR2.LEGISLATION_CODE = PLR1.LEGISLATION_CODE
AND PLR2.RULE_TYPE = 'PAI_END_DATE'
AND /* INPUT VALUES/ELEMENT TYPES JOINS
, */ PIVF1.INPUT_VALUE_ID = FND_NUMBER.CANONICAL_TO_NUMBER(PLR1.RULE_MODE)
AND PIVF2.INPUT_VALUE_ID = FND_NUMBER.CANONICAL_TO_NUMBER(PLR2.RULE_MODE)
AND PEEF.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
AND PEEF.EFFECTIVE_START_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PEEF.EFFECTIVE_END_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PEEF.ENTRY_TYPE = 'E'
AND /* - PAY ADVANCE INDICATOR
, START DATE :*/ PEEVF1.ELEMENT_ENTRY_ID = PEEF.ELEMENT_ENTRY_ID
AND PEEVF1.EFFECTIVE_START_DATE = PEEF.EFFECTIVE_START_DATE
AND PEEVF1.EFFECTIVE_END_DATE = PEEF.EFFECTIVE_END_DATE
AND PEEVF1.INPUT_VALUE_ID = PIVF1.INPUT_VALUE_ID
AND /* - PAY ADVANCE INDICATOR
, END DATE: */ PEEVF2.ELEMENT_ENTRY_ID = PEEF.ELEMENT_ENTRY_ID
AND PEEVF2.EFFECTIVE_START_DATE = PEEF.EFFECTIVE_START_DATE
AND PEEVF2.EFFECTIVE_END_DATE = PEEF.EFFECTIVE_END_DATE
AND PEEVF2.INPUT_VALUE_ID = PIVF2.INPUT_VALUE_ID
AND /* ENFORCE DATE CONDITIONS DESCRIBED IN COMMENTS ABOVE: */ FS.SESSION_ID = USERENV('SESSIONID')
AND FND_DATE.CANONICAL_TO_DATE (PEEVF2.SCREEN_ENTRY_VALUE) >= FS.EFFECTIVE_DATE

Columns