APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_PAYROLLS_F

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

2772: per_assignment_status_types past,
2773: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
2774: hr_all_organization_units hou, /*Bug 3953706 */
2775: hr_all_organization_units hou1 /*Bug 4132525*/
2776: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/
2777: where pap.person_id = paa.person_id
2778: and paa.assignment_id = c_assignment_id
2779: and paa.business_group_id = c_business_group_id
2780: and paa.grade_id = pgr.grade_id(+) /* Bug 3953702*/

Line 2815: pay_payrolls_f pay

2811: c_end_date date)
2812: IS
2813: SELECT paaf.payroll_id, pay.payroll_name
2814: FROM per_all_assignments_f paaf,
2815: pay_payrolls_f pay
2816: WHERE paaf.assignment_id = c_assignment_id
2817: and paaf.effective_end_date = (select max(effective_end_date)
2818: From per_assignments_f iipaf
2819: WHERE iipaf.assignment_id = c_assignment_id

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

3007:
3008: l_max_asg_action_id number; /*Bug 4040688*/
3009: l_max_action_sequence number; /*Bug 4040688*/
3010: l_payroll_id number; /*Bug 4688872*/
3011: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688872*/
3012:
3013: /* Bug 3531704 */
3014: --------------------------------------------------------------------+
3015: -- Name : get_fin_year_code