[Home] [Help]
3025: Main Entry Will be processed in the Enroll Pensions even before this Procedure is called.
3026: */
3027: PROCEDURE AGGREGATED(
3028: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
3029: L_QUALIFYING_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE ,
3030: L_AGGREGATION_FLAG VARCHAR2,
3031: L_AUTO_ENROLLMENT_DATE DATE,
3032: L_QUALIFYING_SCHEME_EXISTS VARCHAR2 ,
3033: L_POSTPONEMENT_TYPE VARCHAR2,
3960: /* -- Bug 14210213
3961: CURSOR C_QUALIFYING_SCHEME_EXISTS (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)
3962: IS
3963: SELECT PPSV.PENSION_SCHEME_NAME
3964: FROM PQP_GB_PENSION_SCHEMES_V PPSV ,
3965: PQP_CONFIGURATION_VALUES PCV ,
3966: PAY_ELEMENT_TYPES_F PETF ,
3967: PAY_ELEMENT_ENTRIES_F PEEF
3968: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
4078: AND G_PRP_END_DATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
4079: AND G_PRP_END_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE;
4080: */
4081: ------------------------------------------------------------------------------------------
4082: CURSOR C_QUALIFYING_SCHEME_VALID (P_QUAL_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE)
4083: IS
4084: SELECT 1
4085: FROM PQP_CONFIGURATION_VALUES PCV
4086: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
4206: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
4207:
4208: ------------------------------------------------------------------------------------------
4209: --13 Input values of Pension Info Element
4210: L_QUALIFYING_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4211: L_AGGREGATION_FLAG VARCHAR2(5) :=NULL;
4212: L_AUTO_ENROLLMENT_DATE DATE :=NULL;
4213: L_QUALIFYING_SCHEME_EXISTS VARCHAR2(5) :=NULL;
4214: L_POSTPONEMENT_TYPE VARCHAR2(100) :=NULL;--New
4222: L_ELIGIBLE_JH_DATE DATE :=NULL;
4223: -- Other Local Variables
4224: L_MAX_POSTPO_DATE DATE;
4225: L_ASSIGN_NUM_CHECK PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE :=NULL;
4226: L_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4227: L_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4228: L_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
4229: L_AGE_START NUMBER :=0;
4230: L_AGE_END NUMBER :=0;
4223: -- Other Local Variables
4224: L_MAX_POSTPO_DATE DATE;
4225: L_ASSIGN_NUM_CHECK PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE :=NULL;
4226: L_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4227: L_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4228: L_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
4229: L_AGE_START NUMBER :=0;
4230: L_AGE_END NUMBER :=0;
4231: L_DATE_OF_BIRTH DATE :=NULL;
4224: L_MAX_POSTPO_DATE DATE;
4225: L_ASSIGN_NUM_CHECK PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE :=NULL;
4226: L_EMPLOYER_COMPONENT PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4227: L_DEFAULT_SCHEME_NAME PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4228: L_DEFAULT_SCH_ELEMENT_NAME PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME%TYPE :=NULL;
4229: L_AGE_START NUMBER :=0;
4230: L_AGE_END NUMBER :=0;
4231: L_DATE_OF_BIRTH DATE :=NULL;
4232: L_EMPLOYEE_STATUS_FOR_PENSION NUMBER;
4258: L_FLAG_TEMP BOOLEAN := FALSE;
4259: l_history number;
4260: L_STAGING_DATE_EARNINGS number;
4261: L_PENSION_STATUS_SD number;
4262: l_qps_on_staging_date PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4263: --Bug 14649941
4264: L_EARNINGS_OLD NUMBER :=0; -- bug 16102066
4265: L_EMPLOYEE_PENSION_CLASS_OLD VARCHAR2(100) :=NULL;--bug 16102066
4266: L_PENSION_STAGING_DATE_TEMP HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE; -- bug 16178067