APPS.HR_AU_TAX_API dependencies on PAY_INPUT_VALUES_F

Line 154: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS

150: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
151: AND legislation_code = 'AU';
152:
153:
154: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
155: SELECT piv.input_value_id
156: ,piv.name
157: FROM pay_input_values_f piv
158: WHERE piv.element_type_id = p_element_type_id

Line 157: FROM pay_input_values_f piv

153:
154: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
155: SELECT piv.input_value_id
156: ,piv.name
157: FROM pay_input_values_f piv
158: WHERE piv.element_type_id = p_element_type_id
159: AND l_session_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
160:
161:

Line 795: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS

791: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
792: AND legislation_code = 'AU';
793:
794:
795: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
796: SELECT piv.input_value_id
797: ,piv.name
798: FROM pay_input_values_f piv
799: WHERE piv.element_type_id = p_element_type_id

Line 798: FROM pay_input_values_f piv

794:
795: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
796: SELECT piv.input_value_id
797: ,piv.name
798: FROM pay_input_values_f piv
799: WHERE piv.element_type_id = p_element_type_id
800: AND l_session_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
801:
802:

Line 1230: (p_element_type_id pay_input_values_f.element_type_id%type

1226: --
1227: l_procedure constant varchar2(60) := 'get_paye_input_ids';
1228: --
1229: cursor csr_paye_input_values
1230: (p_element_type_id pay_input_values_f.element_type_id%type
1231: ,p_effective_date date
1232: ) is
1233: select piv.input_value_id
1234: , piv.name

Line 1235: from pay_input_values_f piv

1231: ,p_effective_date date
1232: ) is
1233: select piv.input_value_id
1234: , piv.name
1235: from pay_input_values_f piv
1236: where piv.element_type_id = p_element_type_id
1237: and p_effective_date between piv.effective_start_date and piv.effective_end_date
1238: order by piv.display_sequence;
1239: --