APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 161: FROM pay_input_values_f piv

157:
158: CURSOR csr_input_value_uom(p_input_value_id NUMBER,
159: p_effective_date DATE) IS
160: SELECT piv.uom
161: FROM pay_input_values_f piv
162: WHERE piv.input_value_id = p_input_value_id
163: AND p_effective_date BETWEEN
164: piv.effective_start_date AND piv.effective_end_date;
165:

Line 343: pay_input_values_f piv,

339: NVL(pet.reporting_name,pet.element_name) element_name,
340: pec.classification_name,
341: piv.uom
342: FROM pay_element_classifications pec,
343: pay_input_values_f piv,
344: pay_element_types_f pet
345: WHERE pec.classification_name IN
346: ('Court Orders',
347: 'Voluntary Deductions',

Line 380: pay_input_values_f piv,

376: NVL(pet.reporting_name,pet.element_name) element_name,
377: 'Information',
378: piv.uom
379: FROM pay_element_classifications pec,
380: pay_input_values_f piv,
381: pay_element_types_f pet
382: WHERE pec.classification_name IN ( 'Information')
383: AND pec.business_group_id IS NULL
384: AND pec.legislation_code = 'IE'

Line 759: FROM pay_input_values_f piv,

755: CURSOR csr_input_value_id(p_element_name CHAR,
756: p_value_name CHAR) IS
757: SELECT pet.element_type_id,
758: piv.input_value_id
759: FROM pay_input_values_f piv,
760: pay_element_types_f pet
761: WHERE piv.element_type_id = pet.element_type_id
762: AND pet.legislation_code = 'IE'
763: AND pet.element_name = p_element_name

Line 1734: FROM pay_input_values_f piv,

1730: /* CURSOR csr_input_value_id(p_element_name CHAR,
1731: p_value_name CHAR) IS
1732: SELECT pet.element_type_id,
1733: piv.input_value_id
1734: FROM pay_input_values_f piv,
1735: pay_element_types_f pet
1736: WHERE piv.element_type_id = pet.element_type_id
1737: AND pet.legislation_code = 'IE'
1738: AND pet.element_name = p_element_name

Line 2841: FROM pay_input_values_f piv,

2837: CURSOR csr_input_value_id(p_element_name CHAR,
2838: p_value_name CHAR) IS
2839: SELECT pet.element_type_id,
2840: piv.input_value_id
2841: FROM pay_input_values_f piv,
2842: pay_element_types_f pet
2843: WHERE piv.element_type_id = pet.element_type_id
2844: AND pet.legislation_code = 'IE'
2845: AND pet.element_name = p_element_name