APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_PAYROLLS_F

Line 930: -- ,pay_payrolls_f papf /*Bug 4688800*/

926: hr_organization_units hou,
927: pay_assignment_actions paa1
928: ,hr_soft_coding_keyflex hsc
929: ,hr_organization_units hou1
930: -- ,pay_payrolls_f papf /*Bug 4688800*/
931: where pap.person_id = paa.person_id
932: and paa.assignment_id = paa1.assignment_id
933: and paa1.assignment_action_id = c_archive_assignment_action_id
934: and paa.business_group_id = c_business_group_id

Line 970: pay_payrolls_f pay

966: c_end_date date)
967: IS
968: SELECT paaf.payroll_id, pay.payroll_name
969: FROM per_all_assignments_f paaf,
970: pay_payrolls_f pay
971: WHERE paaf.assignment_id = c_assignment_id
972: and paaf.effective_end_date = (select max(effective_end_date)
973: From per_assignments_f iipaf
974: WHERE iipaf.assignment_id = c_assignment_id

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

1084:
1085: /* Set Archive Check Date */
1086: l_lst_fbt_yr_start date;
1087: l_payroll_id number; /*Bug 4688800*/
1088: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
1089:
1090: begin
1091:
1092: g_debug :=hr_utility.debug_enabled ;