APPS.PAY_US_MMREF_LOCAL_XML dependencies on PER_ALL_ASSIGNMENTS_F

Line 281: per_all_assignments_f paf,

277: ff_archive_items fai,
278: ff_database_items fdi,
279: pay_assignment_actions paa,
280: pay_payroll_actions ppa,
281: per_all_assignments_f paf,
282: pay_payroll_actions ppa1,
283: pay_us_states pus
284: WHERE ppa1.payroll_action_id = :payroll_action_id
285: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 361: per_all_assignments_f paf,

357: sum(fai1.value)
358: FROM
359: pay_assignment_actions paa, -- YREND PAA
360: pay_payroll_actions ppa, -- YREND PPA
361: per_all_assignments_f paf,
362: pay_payroll_actions ppa1,
363: ff_contexts fc1 , --for city context
364: ff_archive_items fai1, -- city
365: ff_archive_item_contexts faic1, -- city_context

Line 425: per_all_assignments_f paf,

421: sum(fai1.value)
422: FROM
423: pay_assignment_actions paa, -- YREND PAA
424: pay_payroll_actions ppa, -- YREND PPA
425: per_all_assignments_f paf,
426: pay_payroll_actions ppa1,
427: ff_contexts fc1 , --for city context
428: ff_archive_items fai1, -- city
429: ff_archive_item_contexts faic1, -- city_context

Line 945: select person_id from per_all_assignments_f

941: -- l_year_start := '01-JAN-' ||p_reporting_year ;
942: -- l_year_end := '31-DEC-' || p_reporting_year ;
943:
944: cursor c_get_person_id (p_assignment_id in number) is
945: select person_id from per_all_assignments_f
946: where assignment_id = p_assignment_id ;
947:
948: cursor c_get_non_pa_emp_det( p_person_id in number ) is
949: select 'Y' from dual