[Home] [Help]
739: SELECT 1
740: FROM DUAL
741: WHERE EXISTS
742: (SELECT PCV_INFORMATION1
743: FROM PQP_CONFIGURATION_VALUES
744: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
745: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
746: AND PCV_INFORMATION2 = P_SCHEME_ELEMENT_NAME
747: );
2235: trim(PCV_INFORMATION10) PCV_INFORMATION10,
2236: trim(PCV_INFORMATION11) PCV_INFORMATION11,
2237: trim(PCV_INFORMATION12) PCV_INFORMATION12,
2238: trim(PCV_INFORMATION13) PCV_INFORMATION13
2239: FROM PQP_CONFIGURATION_VALUES
2240: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
2241: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
2242: function get_data_file(p_file_name varchar2)
2243: return varchar2
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'
3969: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
3978: */
3979: CURSOR C_QUALIFYING_SCHEME_EXISTS (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)
3980: IS
3981: SELECT PCV.PCV_INFORMATION1
3982: FROM PQP_CONFIGURATION_VALUES PCV ,
3983: PAY_ELEMENT_TYPES_F PETF ,
3984: PAY_ELEMENT_ENTRIES_F PEEF
3985: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
3986: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
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'
4087: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
4088: AND PCV.PCV_INFORMATION1 = P_QUAL_SCHEME_NAME;
4089: ------------------------------------------------------------------------------------------
4144: */
4145: CURSOR C_QPS_EXISTS_ON_STAGING_DATE (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)
4146: IS
4147: SELECT PCV.PCV_INFORMATION1
4148: FROM PQP_CONFIGURATION_VALUES PCV ,
4149: PAY_ELEMENT_TYPES_F PETF ,
4150: PAY_ELEMENT_ENTRIES_F PEEF
4151: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
4152: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
4196: AND PPF.SOFT_CODING_KEYFLEX_ID = HSCF.SOFT_CODING_KEYFLEX_ID
4197: AND HSCF.SEGMENT1 = HOI.ORG_INFORMATION1;
4198:
4199: -- to get custom function name for given pensions scheme
4200: CURSOR C_VALIDATE_CONFIG_VALUE(P_CONFIGURATION_TYPE VARCHAR2, P_SCHEME_NAME PQP_CONFIGURATION_VALUES.PCV_INFORMATION1%TYPE )
4201: IS
4202: SELECT PCV_INFORMATION2
4203: FROM PQP_CONFIGURATION_VALUES
4204: WHERE PCV_INFORMATION_CATEGORY = P_CONFIGURATION_TYPE -- 'PAY_GB_ENROLMENT_CUSTOM_PROC'
4199: -- to get custom function name for given pensions scheme
4200: CURSOR C_VALIDATE_CONFIG_VALUE(P_CONFIGURATION_TYPE VARCHAR2, P_SCHEME_NAME PQP_CONFIGURATION_VALUES.PCV_INFORMATION1%TYPE )
4201: IS
4202: SELECT PCV_INFORMATION2
4203: FROM PQP_CONFIGURATION_VALUES
4204: WHERE PCV_INFORMATION_CATEGORY = P_CONFIGURATION_TYPE -- 'PAY_GB_ENROLMENT_CUSTOM_PROC'
4205: AND PCV_INFORMATION1 = P_SCHEME_NAME
4206: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
4207:
4267: -- bug 14380856
4268: --Bug 16394694
4269: l_asg_start_date Date;
4270: --Bug 16394694
4271: L_CUSTOM_PROCEDURE PQP_CONFIGURATION_VALUES.PCV_INFORMATION2%type := null; -- ER 14380856
4272: L_STMT varchar2(200) := null; -- ER 14380856
4273: l_status number :=2; -- ER 14380856
4274: l_custom_eff_date date;-- ER 14380856
4275: L_EXCEPTION_NO_ERROR EXCEPTION;-- Nothing to be Done. Just Skip the Assignment