APPS.PAY_FI_ARCHIVE_MTRA dependencies on PER_ALL_PEOPLE_F

Line 454: per_all_people_f per,

450: ) is
451: select eev1.screen_entry_value screen_entry_value
452: from per_all_assignments_f asg1,
453: per_all_assignments_f asg2,
454: per_all_people_f per,
455: pay_element_links_f el,
456: pay_element_types_f et,
457: pay_input_values_f iv1,
458: pay_element_entries_f ee,

Line 480: l_person_id per_all_people_f.person_id%type := -1;

476: and eev1.input_value_id = iv1.input_value_id
477: and p_value_date between ee.effective_start_date and ee.effective_end_date
478: and p_value_date between eev1.effective_start_date and eev1.effective_end_date;
479:
480: l_person_id per_all_people_f.person_id%type := -1;
481: l_month_start_date date;
482:
483: /* End of Cursors */
484: