APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_PAYROLLS_F

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

1300: hr_all_organization_units hou,
1301: pay_assignment_actions paa1
1302: ,hr_soft_coding_keyflex hsc
1303: ,hr_all_organization_units hou1
1304: -- ,pay_payrolls_f papf /*Bug 4688800*/
1305: where pap.person_id = paa.person_id
1306: and paa.assignment_id = paa1.assignment_id
1307: and paa1.assignment_action_id = c_archive_assignment_action_id
1308: and paa.business_group_id = c_business_group_id

Line 1345: pay_payrolls_f pay

1341: c_end_date date)
1342: IS
1343: SELECT paaf.payroll_id, pay.payroll_name
1344: FROM per_all_assignments_f paaf,
1345: pay_payrolls_f pay
1346: WHERE paaf.assignment_id = c_assignment_id
1347: and paaf.effective_end_date = (select max(effective_end_date)
1348: From per_assignments_f iipaf
1349: WHERE iipaf.assignment_id = c_assignment_id

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

1462: l_le_etp_service_date date; /* Bug 4177679 */
1463: l_result NUMBER;
1464: l_lst_fbt_yr_start date;
1465: l_payroll_id number; /*Bug 4688800*/
1466: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
1467: l_etp_new_bal_total number ; /* Bug 9226023 - Variable declared to hold the sum of Taxable and Tax Free portions of
1468: ETP balances introduced as part of bug 8769345*/
1469: /* Changes for 9147438 start */
1470: l_fw_f_type varchar2(1);