DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PER_ASSIGNMENTS_F

Line 1387: per_assignments_f paf,

1383: is
1384: select count(DISTINCT ptp.time_period_id)
1385: from per_time_periods ptp
1386: where exists (select 'EXISTS' from
1387: per_assignments_f paf,
1388: hr_soft_coding_keyflex hsck
1389: where paf.assignment_id = p_assignment_id
1390: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
1391: and hsck.segment1 = c_tax_unit_id

Line 1419: per_assignments_f paf

1415: IS
1416: SELECT count(paa.assignment_action_id)
1417: FROM pay_assignment_actions paa,
1418: pay_payroll_actions ppa,
1419: per_assignments_f paf
1420: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
1421: AND ppa.business_group_id = c_business_group_id
1422: AND ppa.payroll_action_id = paa.payroll_action_id
1423: AND paa.assignment_id = c_assignment_id