DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 1865: FROM per_all_assignments_f paf

1861:
1862: CURSOR c_fetch_Ann_adj(cp_person_id NUMBER
1863: ,cd_end_date DATE ) is
1864: SELECT distinct 'Y'
1865: FROM per_all_assignments_f paf
1866: WHERE paf.person_id = cp_person_id
1867: AND EXISTS ( SELECT 1
1868: FROM pay_assignment_actions paa
1869: ,pay_payroll_actions ppa

Line 1886: FROM per_all_assignments_f paf

1882: ,cp_person_id NUMBER) IS
1883: SELECT pay_mx_utility.get_legi_param_val('CALC_MODE'
1884: ,legislative_parameters)
1885: ,paa.assignment_action_id
1886: FROM per_all_assignments_f paf
1887: ,pay_assignment_actions paa
1888: ,pay_payroll_actions ppa
1889: WHERE person_id = cp_person_id
1890: AND paa.payroll_action_id = ppa.payroll_action_id