APPS.PAY_DK_TCR dependencies on PER_ALL_ASSIGNMENTS_F

Line 27: l_bg_id per_all_assignments_f.business_group_id%type;

23: l_cpr_number VARCHAR2(15);
24: l_req_status VARCHAR2(25);
25: l_tax_card_type VARCHAR2(3);
26: l_sex VARCHAR2(1);
27: l_bg_id per_all_assignments_f.business_group_id%type;
28: l_le_id VARCHAR2(60);
29: l_style per_addresses_v.style%type;
30: l_flag NUMBER:=0;
31: l_effective_start_date DATE;

Line 71: from per_all_assignments_f paa,

67: CURSOR csr_get_person_id(p_le_id VARCHAR2, p_bg_id NUMBER)
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

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 88: FROM --per_all_assignments_f asg1

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
91: ,pay_element_entries_f ee
92: ,pay_element_entry_values_f eev1