APPS.PAY_IE_PAYE_API dependencies on PAY_IE_PAYE_DETAILS_F

Line 291: FROM pay_ie_paye_details_f

287: */
288: --
289: CURSOR cur_p45p3_eff_start_date IS
290: SELECT min(effective_start_date)
291: FROM pay_ie_paye_details_f
292: WHERE paye_details_id = p_paye_details_id;
293: --AND p_effective_date BETWEEN effective_start_date AND effective_end_date
294: --AND effective_start_date >= l_tax_yr_start_date
295: --AND effective_end_date <= add_months(l_tax_yr_start_date,12);

Line 297: l_p45p3_eff_start_date pay_ie_paye_details_f.effective_start_date%type;

293: --AND p_effective_date BETWEEN effective_start_date AND effective_end_date
294: --AND effective_start_date >= l_tax_yr_start_date
295: --AND effective_end_date <= add_months(l_tax_yr_start_date,12);
296: --
297: l_p45p3_eff_start_date pay_ie_paye_details_f.effective_start_date%type;
298: l_datetrack_update_mode VARCHAR2(100);
299:
300: begin
301:

Line 417: -- if mode is Correction then create the record with same eff start date as in pay_ie_paye_details_f table

413: ELSE
414: --OPEN entry_csr_any;
415: --FETCH entry_csr_any INTO rec_entry_csr_any;
416: --IF entry_csr_any%NOTFOUND THEN
417: -- if mode is Correction then create the record with same eff start date as in pay_ie_paye_details_f table
418: -- if mode is updation then create the record with effective date passed.
419: --
420: /*
421: IF p_datetrack_update_mode = 'CORRECTION' THEN

Line 944: -- Insert record in pay_ie_paye_details_f

940: l_prog_appl_id := fnd_global.prog_appl_id;
941: l_program_id := fnd_global.conc_program_id;
942: l_comm_period_no := pay_ipd_bus.get_comm_period_no(p_effective_date => p_effective_date , p_assignment_id => p_assignment_id);
943: --
944: -- Insert record in pay_ie_paye_details_f
945: --
946: pay_ipd_ins.ins
947: ( p_effective_date => p_effective_date
948: ,p_assignment_id => p_assignment_id

Line 1296: FROM pay_ie_paye_details_f

1292: l_business_group_id number;
1293: --
1294: CURSOR asg_csr IS
1295: SELECT assignment_id
1296: FROM pay_ie_paye_details_f
1297: WHERE paye_details_id = p_paye_details_id
1298: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1299: --
1300: CURSOR business_group_csr IS

Line 1551: FROM pay_ie_paye_details_f

1547: -- we now deleet all bal adj with the effective date tax year
1548: /*
1549: SELECT min(effective_start_date)
1550: INTO l_p45_effective_date
1551: FROM pay_ie_paye_details_f
1552: WHERE paye_details_id = p_paye_details_id;
1553:
1554: --
1555: IF l_p45_effective_date < to_date('01-JAN-'||to_char(p_effective_date,'YYYY'), 'DD/MM/YYYY') THEN

Line 1832: FROM pay_ie_paye_details_f

1828: l_business_group_id number;
1829: --
1830: CURSOR asg_csr IS
1831: SELECT assignment_id
1832: FROM pay_ie_paye_details_f
1833: WHERE paye_details_id = p_paye_details_id
1834: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1835: --
1836: CURSOR business_group_csr IS

Line 1909: FROM pay_ie_paye_details_f

1905: -- we now deleet all bal adj with the effective date tax year
1906: /*
1907: SELECT min(effective_start_date)
1908: INTO l_p45_effective_date
1909: FROM pay_ie_paye_details_f
1910: WHERE paye_details_id = p_paye_details_id;
1911: --
1912: IF l_p45_effective_date < to_date('01-JAN-'||to_char(p_effective_date,'YYYY'), 'DD/MM/YYYY') THEN
1913: l_p45_effective_date := to_date('01-JAN-'||to_char(p_effective_date,'YYYY'), 'DD/MM/YYYY') ;