DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PQP_CONFIGURATION_VALUES

Line 43: FROM PQP_CONFIGURATION_VALUES PCV,

39: IS
40: SELECT PCV.PCV_INFORMATION1,
41: PCV.PCV_INFORMATION2,PCV.PCV_INFORMATION3,
42: PCV.PCV_INFORMATION4
43: FROM PQP_CONFIGURATION_VALUES PCV,
44: PAY_PAYROLLS_F PPF
45: WHERE PCV.PCV_INFORMATION_CATEGORY like 'PAY_GB_ENROLMENT_COMM_DETAILS'
46: AND PPF.business_group_id = PCV.business_group_id
47: AND PPF.PAYROLL_ID = P_PAYROLL_ID ;

Line 54: FROM PQP_CONFIGURATION_VALUES PCV,

50: CURSOR c_comm_details_qual(P_PAYROLL_ID number,P_QUALIFYING_SCHEME VARCHAR) -- Comm Details from Qualifying Scheme
51: IS
52: SELECT PCV.PCV_INFORMATION14,
53: PCV.PCV_INFORMATION15,PCV.PCV_INFORMATION16,PCV.PCV_INFORMATION17
54: FROM PQP_CONFIGURATION_VALUES PCV,
55: PAY_PAYROLLS_F PPF
56: WHERE PCV.PCV_INFORMATION_CATEGORY like 'PAY_GB_QUALIFIED_PENSIONS_INFO'
57: AND PPF.business_group_id = PCV.business_group_id
58: AND PCV.PCV_INFORMATION1 = P_QUALIFYING_SCHEME