APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 148: FROM pay_element_types_f pet,

144:
145: CURSOR csr_element_type(p_element_type_id NUMBER,
146: p_effective_date DATE) IS
147: SELECT pet.formula_id
148: FROM pay_element_types_f pet,
149: ff_formulas_f fff
150: WHERE pet.element_type_id = p_element_type_id
151: AND pet.formula_id = fff.formula_id
152: AND fff.formula_name = 'ONCE_EACH_PERIOD'

Line 344: pay_element_types_f pet

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',
348: 'Pre-Tax Deductions',

Line 381: pay_element_types_f pet

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'
385: AND pet.classification_id = pec.classification_id

Line 760: pay_element_types_f pet

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
764: AND piv.name = p_value_name;

Line 1735: pay_element_types_f pet

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
1739: AND piv.name = p_value_name;

Line 2842: pay_element_types_f pet

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
2846: AND piv.name = p_value_name;