APPS.PAY_AU_RECONCILIATION_PKG dependencies on PAY_PAYROLLS_F

Line 1765: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/

1761: per_assignments_f paa,
1762: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1763: hr_organization_units hou, /*Bug 4132525*/
1764: hr_organization_units hou1 /*Bug 4132525*/
1765: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688800*/
1766: where pap.person_id = paa.person_id
1767: and paa.assignment_id = c_assignment_id
1768: and paa.business_group_id = c_business_group_id
1769: AND hsc.soft_coding_keyflex_id = paa.soft_coding_keyflex_id /*Bug 4040688*/

Line 1788: pay_payrolls_f pay

1784: CURSOR c_get_payroll_name(c_assignment_id number,c_end_date date, c_start_date date)
1785: IS
1786: SELECT paaf.payroll_id, pay.payroll_name
1787: FROM per_all_assignments_f paaf,
1788: pay_payrolls_f pay
1789: WHERE paaf.assignment_id = c_assignment_id
1790: and paaf.effective_end_date = (select max(effective_end_date)
1791: From per_assignments_f iipaf
1792: WHERE iipaf.assignment_id = c_assignment_id

Line 1882: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/

1878: l_max_asg_action_id number; /*Bug 4040688*/
1879: l_max_action_sequence number; /*Bug 4040688*/
1880:
1881: l_payroll_id number; /*Bug 4688800*/
1882: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
1883:
1884: begin
1885:
1886: g_debug :=hr_utility.debug_enabled ;