APPS.PAY_IE_PAYE_API dependencies on PAY_IE_PAYE_DETAILS_F

Line 258: FROM pay_ie_paye_details_f

254: */
255: --
256: CURSOR cur_p45p3_eff_start_date IS
257: SELECT min(effective_start_date)
258: FROM pay_ie_paye_details_f
259: WHERE paye_details_id = p_paye_details_id;
260: --AND p_effective_date BETWEEN effective_start_date AND effective_end_date
261: --AND effective_start_date >= l_tax_yr_start_date
262: --AND effective_end_date <= add_months(l_tax_yr_start_date,12);

Line 264: l_p45p3_eff_start_date pay_ie_paye_details_f.effective_start_date%type;

260: --AND p_effective_date BETWEEN effective_start_date AND effective_end_date
261: --AND effective_start_date >= l_tax_yr_start_date
262: --AND effective_end_date <= add_months(l_tax_yr_start_date,12);
263: --
264: l_p45p3_eff_start_date pay_ie_paye_details_f.effective_start_date%type;
265: l_datetrack_update_mode VARCHAR2(100);
266:
267: begin
268:

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

355: ELSE
356: --OPEN entry_csr_any;
357: --FETCH entry_csr_any INTO rec_entry_csr_any;
358: --IF entry_csr_any%NOTFOUND THEN
359: -- if mode is Correction then create the record with same eff start date as in pay_ie_paye_details_f table
360: -- if mode is updation then create the record with effective date passed.
361: --
362: /*
363: IF p_datetrack_update_mode = 'CORRECTION' THEN

Line 768: -- Insert record in pay_ie_paye_details_f

764: l_prog_appl_id := fnd_global.prog_appl_id;
765: l_program_id := fnd_global.conc_program_id;
766: l_comm_period_no := pay_ipd_bus.get_comm_period_no(p_effective_date => p_effective_date , p_assignment_id => p_assignment_id);
767: --
768: -- Insert record in pay_ie_paye_details_f
769: --
770: pay_ipd_ins.ins
771: ( p_effective_date => p_effective_date
772: ,p_assignment_id => p_assignment_id

Line 984: FROM pay_ie_paye_details_f

980: l_business_group_id number;
981: --
982: CURSOR asg_csr IS
983: SELECT assignment_id
984: FROM pay_ie_paye_details_f
985: WHERE paye_details_id = p_paye_details_id
986: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
987: --
988: CURSOR business_group_csr IS

Line 1161: FROM pay_ie_paye_details_f

1157: -- we now deleet all bal adj with the effective date tax year
1158: /*
1159: SELECT min(effective_start_date)
1160: INTO l_p45_effective_date
1161: FROM pay_ie_paye_details_f
1162: WHERE paye_details_id = p_paye_details_id;
1163:
1164: --
1165: IF l_p45_effective_date < to_date('01-JAN-'||to_char(p_effective_date,'YYYY'), 'DD/MM/YYYY') THEN

Line 1369: FROM pay_ie_paye_details_f

1365: l_business_group_id number;
1366: --
1367: CURSOR asg_csr IS
1368: SELECT assignment_id
1369: FROM pay_ie_paye_details_f
1370: WHERE paye_details_id = p_paye_details_id
1371: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1372: --
1373: CURSOR business_group_csr IS

Line 1446: FROM pay_ie_paye_details_f

1442: -- we now deleet all bal adj with the effective date tax year
1443: /*
1444: SELECT min(effective_start_date)
1445: INTO l_p45_effective_date
1446: FROM pay_ie_paye_details_f
1447: WHERE paye_details_id = p_paye_details_id;
1448: --
1449: IF l_p45_effective_date < to_date('01-JAN-'||to_char(p_effective_date,'YYYY'), 'DD/MM/YYYY') THEN
1450: l_p45_effective_date := to_date('01-JAN-'||to_char(p_effective_date,'YYYY'), 'DD/MM/YYYY') ;