APPS.HR_AU_TAX_API dependencies on PAY_INPUT_VALUES_F

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

162: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
163: AND legislation_code = 'AU';
164:
165:
166: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
167: SELECT piv.input_value_id
168: ,piv.name
169: FROM pay_input_values_f piv
170: WHERE piv.element_type_id = p_element_type_id

Line 169: FROM pay_input_values_f piv

165:
166: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
167: SELECT piv.input_value_id
168: ,piv.name
169: FROM pay_input_values_f piv
170: WHERE piv.element_type_id = p_element_type_id
171: AND l_session_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
172:
173:

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

830: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
831: AND legislation_code = 'AU';
832:
833:
834: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
835: SELECT piv.input_value_id
836: ,piv.name
837: FROM pay_input_values_f piv
838: WHERE piv.element_type_id = p_element_type_id

Line 837: FROM pay_input_values_f piv

833:
834: CURSOR csr_paye_tax_input_values(p_element_type_id pay_input_values_f.element_type_id%TYPE) IS
835: SELECT piv.input_value_id
836: ,piv.name
837: FROM pay_input_values_f piv
838: WHERE piv.element_type_id = p_element_type_id
839: AND l_session_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
840:
841:

Line 1269: (p_element_type_id pay_input_values_f.element_type_id%type

1265: --
1266: l_procedure constant varchar2(60) := 'get_paye_input_ids';
1267: --
1268: cursor csr_paye_input_values
1269: (p_element_type_id pay_input_values_f.element_type_id%type
1270: ,p_effective_date date
1271: ) is
1272: select piv.input_value_id
1273: , piv.name

Line 1274: from pay_input_values_f piv

1270: ,p_effective_date date
1271: ) is
1272: select piv.input_value_id
1273: , piv.name
1274: from pay_input_values_f piv
1275: where piv.element_type_id = p_element_type_id
1276: and p_effective_date between piv.effective_start_date and piv.effective_end_date
1277: order by piv.display_sequence;
1278: --