APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_TYPES_F

Line 5: G_ELEMENT_NAME CONSTANT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := 'Pensions Information';

1: PACKAGE PAY_GB_ENROLL_PENSION
2: /* $Header: pygbpaep.pkh 120.16.12020000.3 2013/03/28 10:22:13 rsadhana noship $ */
3: AUTHID CURRENT_USER AS
4: G_END_OF_TIME DATE :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
5: G_ELEMENT_NAME CONSTANT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := 'Pensions Information';
6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';
7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';

Line 82: FROM PAY_ELEMENT_TYPES_F PETF,

78: MAX(DECODE(TRIM(PIVF.NAME),G_OPT_OUT_END_DATE,PIVF.INPUT_VALUE_ID, NULL)) G_OPT_OUT_END_DATE_ID,
79: MAX(DECODE(TRIM(PIVF.NAME),G_MAIN_ENTRY,PIVF.INPUT_VALUE_ID, NULL)) G_MAIN_ENTRY_ID,
80: MAX(DECODE(TRIM(PIVF.NAME),G_TOTAL_EARNING_PRP,PIVF.INPUT_VALUE_ID, NULL)) G_TOTAL_EARNING_PRP_ID,
81: MAX(DECODE(TRIM(PIVF.NAME),G_ELIGIBLE_JH_DATE,PIVF.INPUT_VALUE_ID, NULL)) G_ELIGIBLE_JH_DATE_ID
82: FROM PAY_ELEMENT_TYPES_F PETF,
83: PAY_INPUT_VALUES_F PIVF
84: WHERE PETF.ELEMENT_NAME = G_ELEMENT_NAME
85: AND PETF.ELEMENT_TYPE_ID = PIVF.ELEMENT_TYPE_ID
86: -- AND G_PRP_END_DATE BETWEEN PETF.EFFECTIVE_START_DATE AND PETF.EFFECTIVE_END_DATE

Line 250: G_DEFAULT_ELEMENT_ER PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;--Employer Element

246: WHERE PCV.PCV_INFORMATION_CATEGORY = 'PAY_GB_DEFAULT_PENSIONS_INFO'
247: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID ;
248:
249: G_DEFAULT_PENSION PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%TYPE; -- To hold Default Pension Scheme Name
250: G_DEFAULT_ELEMENT_ER PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;--Employer Element
251: G_DEFAULT_ELEMENT_EE PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --To hold Default Pension Scheme's Element Name
252: G_DEFAULT_PENSION_DUMMY PAY_ELEMENT_TYPE_EXTRA_INFO.EEI_INFORMATION1%TYPE;
253: G_DEFAULT_ELEMENT_DUMMY PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
254:

Line 251: G_DEFAULT_ELEMENT_EE PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --To hold Default Pension Scheme's Element Name

247: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID ;
248:
249: G_DEFAULT_PENSION PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%TYPE; -- To hold Default Pension Scheme Name
250: G_DEFAULT_ELEMENT_ER PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;--Employer Element
251: G_DEFAULT_ELEMENT_EE PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --To hold Default Pension Scheme's Element Name
252: G_DEFAULT_PENSION_DUMMY PAY_ELEMENT_TYPE_EXTRA_INFO.EEI_INFORMATION1%TYPE;
253: G_DEFAULT_ELEMENT_DUMMY PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
254:
255: CURSOR get_assignment_number (p_assignment_id number)

Line 253: G_DEFAULT_ELEMENT_DUMMY PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

249: G_DEFAULT_PENSION PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%TYPE; -- To hold Default Pension Scheme Name
250: G_DEFAULT_ELEMENT_ER PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;--Employer Element
251: G_DEFAULT_ELEMENT_EE PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE; --To hold Default Pension Scheme's Element Name
252: G_DEFAULT_PENSION_DUMMY PAY_ELEMENT_TYPE_EXTRA_INFO.EEI_INFORMATION1%TYPE;
253: G_DEFAULT_ELEMENT_DUMMY PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
254:
255: CURSOR get_assignment_number (p_assignment_id number)
256: is
257: select assignment_number from per_all_assignments_f