APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ALL_PEOPLE_F

Line 746: per_all_people_f pap

742: assign.assignment_number, assign.organization_id, assign.primary_flag
743: FROM
744: pay_assignment_actions pac,
745: per_all_assignments_f assign,
746: per_all_people_f pap
747: WHERE pac.assignment_action_id = p_asg_act_id
748: AND assign.assignment_id = pac.assignment_id
749: AND assign.person_id = pap.person_id
750: AND pap.per_information_category = 'DK'

Line 759: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type) IS

755:
756: rg_csr_get_person_details csr_get_person_details%rowtype;
757:
758: /* Getting the latest hire date */
759: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type) IS
760: SELECT MAX(date_start) lhd FROM per_periods_of_service
761: WHERE person_id=pid;
762:
763: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;

Line 822: ,per_all_people_f per

818: /* Cursor to retrieve Element - Employee ATP*/
819: CURSOR csr_get_atp_table_value(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
820: SELECT eev1.screen_entry_value screen_entry_value
821: FROM per_all_assignments_f asg1
822: ,per_all_people_f per
823: ,pay_element_links_f el
824: ,pay_element_types_f et
825: ,pay_input_values_f iv1
826: ,pay_element_entries_f ee

Line 857: ,per_all_people_f per

853: /* Cursor to retrieve Element - Tax Card*/
854: CURSOR csr_get_tax_card_details(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
855: SELECT ee.effective_start_date, eev1.screen_entry_value
856: FROM per_all_assignments_f asg1
857: ,per_all_people_f per
858: ,pay_element_links_f el
859: ,pay_element_types_f et
860: ,pay_input_values_f iv1
861: ,pay_element_entries_f ee