DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 1619: FROM per_all_assignments_f paf

1615:
1616: CURSOR c_fetch_Ann_adj(cp_person_id NUMBER
1617: ,cd_end_date DATE ) is
1618: SELECT distinct 'Y'
1619: FROM per_all_assignments_f paf
1620: WHERE paf.person_id = cp_person_id
1621: AND EXISTS ( SELECT 1
1622: FROM pay_assignment_actions paa
1623: ,pay_payroll_actions ppa

Line 1640: FROM per_all_assignments_f paf

1636: ,cp_person_id NUMBER) IS
1637: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'
1638: ,legislative_parameters)
1639: ,paa.assignment_action_id
1640: FROM per_all_assignments_f paf
1641: ,pay_assignment_actions paa
1642: ,pay_payroll_actions ppa
1643: WHERE person_id = cp_person_id
1644: AND paa.payroll_action_id = ppa.payroll_action_id