APPS.PAY_DK_TCR dependencies on PAY_INPUT_VALUES_F

Line 33: l_input_value_id pay_input_values_f.input_value_id%type;

29: l_style per_addresses_v.style%type;
30: l_flag NUMBER:=0;
31: l_effective_start_date DATE;
32: l_effective_end_date DATE;
33: l_input_value_id pay_input_values_f.input_value_id%type;
34: l_update_warning BOOLEAN := FALSE;
35:
36: NO_E_INCOME_DATA_SUPPLIER EXCEPTION;
37:

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 90: ,pay_input_values_f iv1

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
93: WHERE -- asg1.assignment_id = p_assignment_id
94: et.element_name = 'Tax Card'