APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 1577: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/

1573: per_assignment_status_types past,
1574: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1575: hr_organization_units hou, /*Bug 3953706 */
1576: hr_organization_units hou1 /*Bug 4132525*/
1577: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/
1578: where pap.person_id = paa.person_id
1579: and paa.assignment_id = c_assignment_id
1580: and paa.business_group_id = c_business_group_id
1581: and paa.grade_id = pgr.grade_id(+) /* Bug 3953702*/

Line 1616: pay_payrolls_f pay

1612: c_end_date date)
1613: IS
1614: SELECT paaf.payroll_id, pay.payroll_name
1615: FROM per_all_assignments_f paaf,
1616: pay_payrolls_f pay
1617: WHERE paaf.assignment_id = c_assignment_id
1618: and paaf.effective_end_date = (select max(effective_end_date)
1619: From per_assignments_f iipaf
1620: WHERE iipaf.assignment_id = c_assignment_id

Line 1807: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688872*/

1803:
1804: l_max_asg_action_id number; /*Bug 4040688*/
1805: l_max_action_sequence number; /*Bug 4040688*/
1806: l_payroll_id number; /*Bug 4688872*/
1807: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688872*/
1808:
1809: /* Bug 3531704 */
1810: --------------------------------------------------------------------+
1811: -- Name : get_fin_year_code