APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_PAYROLLS_F

Line 1153: FROM pay_payrolls_f prl

1149: CURSOR csr_pay_ppg (c_effective_date IN DATE
1150: ,c_payroll_id IN NUMBER
1151: ) IS
1152: SELECT prl.prl_information7 -- PPG Code
1153: FROM pay_payrolls_f prl
1154: WHERE prl.payroll_id = c_payroll_id
1155: AND prl.prl_information_category = 'US'
1156: AND c_effective_date BETWEEN prl.effective_start_date
1157: AND prl.effective_end_date;

Line 1233: FROM pay_payrolls_f prl

1229: CURSOR csr_pay_ppg (c_effective_date IN DATE
1230: ,c_payroll_id IN NUMBER
1231: ) IS
1232: SELECT prl.prl_information4 -- Payment Mode
1233: FROM pay_payrolls_f prl
1234: WHERE prl.payroll_id = c_payroll_id
1235: AND prl.prl_information_category = 'US'
1236: AND c_effective_date BETWEEN prl.effective_start_date
1237: AND prl.effective_end_date;

Line 4799: FROM pay_payrolls_f pay

4795: CURSOR csr_pay_name(c_payroll_id IN NUMBER
4796: ,c_end_date IN DATE
4797: )IS
4798: SELECT pay.payroll_name
4799: FROM pay_payrolls_f pay
4800: WHERE pay.payroll_id = c_payroll_id
4801: AND c_end_date BETWEEN pay.effective_start_date
4802: AND pay.effective_end_date;
4803:

Line 4814: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;

4810: l_extract_name ben_ext_dfn.NAME%TYPE;
4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
4812: l_element_name pay_element_types_f.element_name%TYPE;
4813: l_gre_name hr_organization_units.NAME%TYPE ;
4814: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
4815: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
4816:
4817: BEGIN
4818: Hr_Utility.set_location('Entering: '||l_proc_name, 5);