APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 110: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEVF

106: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_OPT_OUT_END_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_OPT_OUT_END_DATE,
107: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_MAIN_ENTRY_ID,SCREEN_ENTRY_VALUE, NULL)) G_MAIN_ENTRY,
108: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_TOTAL_EARNING_PRP_ID,SCREEN_ENTRY_VALUE, NULL)) G_TOTAL_EARNING_PRP,
109: MAX(DECODE(TRIM(PEEVF.INPUT_VALUE_ID),G_ELEMENT_DETAILS.G_ELIGIBLE_JH_DATE_ID,SCREEN_ENTRY_VALUE, NULL)) G_ELIGIBLE_JH_DATE
110: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEVF
111: WHERE PEEVF.INPUT_VALUE_ID IN (G_ELEMENT_DETAILS.G_QUALIFYING_SCHEME_NAME_ID ,
112: G_ELEMENT_DETAILS.G_AGG_EARNINGS_PENSIONS_ID ,
113: G_ELEMENT_DETAILS.G_AUTO_ENROLLMENT_DATE_ID ,
114: G_ELEMENT_DETAILS.G_QUALIFYING_PS_EXISTS_ID ,

Line 189: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEVF ,

185: --Fetch Screen entry value, if any, attached to the element
186: CURSOR C_SCREEN_ENTRY_VALUE(P_ELEMENT_ENTRY_ID VARCHAR2,P_EFFECTIVE_DATE DATE)
187: IS
188: SELECT PEEVF.SCREEN_ENTRY_VALUE
189: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEVF ,
190: PAY_INPUT_VALUES_F PIVF
191: WHERE PEEVF.ELEMENT_ENTRY_ID = P_ELEMENT_ENTRY_ID
192: AND PIVF.NAME ='Pay Value'
193: AND PEEVF.INPUT_VALUE_ID =PIVF.INPUT_VALUE_ID

Line 208: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEF, PAY_INPUT_VALUES_F PIVF

204: --Fetch Screen Entry value for an input value
205: CURSOR ELE_SCREEN_VALUE (P_ELEM_ENTRY_ID NUMBER)
206: IS
207: SELECT PEEF.SCREEN_ENTRY_VALUE, PEEF.INPUT_VALUE_ID, UPPER(REPLACE(PIVF.NAME,' ','_')) NAME
208: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEF, PAY_INPUT_VALUES_F PIVF
209: WHERE PEEF.ELEMENT_ENTRY_ID = P_ELEM_ENTRY_ID
210: AND PEEF.INPUT_VALUE_ID = PIVF.INPUT_VALUE_ID
211: AND G_PRP_END_DATE >= ALL(PEEF.EFFECTIVE_START_DATE,PIVF.EFFECTIVE_START_DATE )
212: AND G_PRP_START_DATE <= ALL(PEEF.EFFECTIVE_END_DATE,PIVF.EFFECTIVE_END_DATE ) ;