APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ALL_PEOPLE_F

Line 874: per_all_people_f pap

870: assign.location_id
871: FROM
872: pay_assignment_actions pac,
873: per_all_assignments_f assign,
874: per_all_people_f pap
875: WHERE pac.assignment_action_id = p_asg_act_id
876: AND assign.assignment_id = pac.assignment_id
877: AND assign.person_id = pap.person_id
878: AND pap.per_information_category = 'DK'

Line 888: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type

884: rg_csr_get_person_details csr_get_person_details%rowtype;
885:
886: /* Getting the latest hire date */
887: /* For Bug 9011035 */
888: CURSOR csr_latest_hire_date(pid per_all_people_f.person_id%type
889: ,p_end_date DATE) IS
890: SELECT MAX(date_start) lhd FROM per_periods_of_service
891: WHERE person_id=pid
892: AND date_start <= p_end_date;

Line 897: CURSOR csr_get_extra_person_info(pid per_all_people_f.person_id%type) IS

893:
894: rg_csr_latest_hire_date csr_latest_hire_date%rowtype;
895:
896: /* Cursor to get the extra person info - Foreigner (yes/no) */ -- bug 13880339
897: CURSOR csr_get_extra_person_info(pid per_all_people_f.person_id%type) IS
898: SELECT PEI_INFORMATION1 yes_no ,PEI_INFORMATION2 stationed_abroad FROM per_people_extra_info
899: WHERE person_id=pid
900: AND information_type='DK_EINCOME_FORIEGN_IND';
901:

Line 905: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS

901:
902: rg_csr_get_extra_person_info csr_get_extra_person_info%rowtype;
903:
904: /* Get the territory */
905: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS
906: SELECT *
907: FROM per_addresses_v
908: WHERE person_id =pid
909: and primary_flag='Y';

Line 1013: ,per_all_people_f per

1009: /* Cursor to retrieve Element - Employee ATP*/
1010: CURSOR csr_get_atp_table_value(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1011: SELECT eev1.screen_entry_value screen_entry_value
1012: FROM per_all_assignments_f asg1
1013: ,per_all_people_f per
1014: ,pay_element_links_f el
1015: ,pay_element_types_f et
1016: ,pay_input_values_f iv1
1017: ,pay_element_entries_f ee

Line 1048: ,per_all_people_f per

1044: /* Cursor to retrieve Element - Tax Card*/
1045: CURSOR csr_get_tax_card_details(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1046: SELECT ee.effective_start_date, eev1.screen_entry_value
1047: FROM per_all_assignments_f asg1
1048: ,per_all_people_f per
1049: ,pay_element_links_f el
1050: ,pay_element_types_f et
1051: ,pay_input_values_f iv1
1052: ,pay_element_entries_f ee