APPS.PAY_DK_TCR dependencies on PER_ALL_PEOPLE_F

Line 72: per_all_people_f pap, hr_soft_coding_keyflex scl where

68: IS
69: select pap.person_id, paa.assignment_id, pap.NATIONAL_IDENTIFIER, paa.assignment_number, to_char(pap.date_of_birth,'yyyymmdd') dob,
70: first_name||' '||middle_names||' '||last_name pname, pap.effective_start_date
71: from per_all_assignments_f paa,
72: per_all_people_f pap, hr_soft_coding_keyflex scl where
73: paa.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
74: and scl.segment1 = p_le_id
75: and paa.business_group_id = p_bg_id
76: and paa.PRIMARY_FLAG='Y'

Line 86: CURSOR csr_get_tax_card_details(p_assignment_id per_all_assignments_f.assignment_id%type, p_input_value pay_input_values_f.name%type, p_hire_date per_all_people_f.effective_start_date%type) IS

82:
83: rg_csr_get_person_id csr_get_person_id%ROWTYPE;
84:
85: /* Get the tax card details */
86: CURSOR csr_get_tax_card_details(p_assignment_id per_all_assignments_f.assignment_id%type, p_input_value pay_input_values_f.name%type, p_hire_date per_all_people_f.effective_start_date%type) IS
87: SELECT ee.effective_start_date, eev1.screen_entry_value, ee.element_entry_id, ee.object_version_number, iv1.input_value_id
88: FROM --per_all_assignments_f asg1
89: pay_element_types_f et
90: ,pay_input_values_f iv1

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

106:
107: rg_csr_get_tax_card_details csr_get_tax_card_details%rowtype;
108:
109: /* Get the territory */
110: CURSOR csr_get_territory(pid per_all_people_f.person_id%type) IS
111: SELECT *
112: FROM per_addresses_v
113: WHERE person_id =pid
114: and primary_flag='Y'