APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 152: FROM pay_element_types_f pet,

148:
149: CURSOR csr_element_type(p_element_type_id NUMBER,
150: p_effective_date DATE) IS
151: SELECT pet.formula_id
152: FROM pay_element_types_f pet,
153: ff_formulas_f fff
154: WHERE pet.element_type_id = p_element_type_id
155: AND pet.formula_id = fff.formula_id
156: AND fff.formula_name = 'ONCE_EACH_PERIOD'

Line 383: pay_element_types_f pet

379: pec.classification_name,
380: piv.uom
381: FROM pay_element_classifications pec,
382: pay_input_values_f piv,
383: pay_element_types_f pet
384: WHERE pec.classification_name IN ('Court Orders','Voluntary Deductions','Pre Tax Deductions',
385: 'PAYE','NI','Earnings','Direct Payment','Pre NI Deductions','Pre Tax and NI Deductions')
386: AND pec.business_group_id IS NULL
387: AND pec.legislation_code = 'GB'

Line 605: pay_element_types_f pet

601: p_value_name CHAR) IS
602: SELECT pet.element_type_id,
603: piv.input_value_id
604: FROM pay_input_values_f piv,
605: pay_element_types_f pet
606: WHERE piv.element_type_id = pet.element_type_id
607: AND pet.legislation_code = 'GB'
608: AND pet.element_name = p_element_name
609: AND piv.name = p_value_name;

Line 1409: pay_element_types_f pet

1405: p_value_name CHAR) IS
1406: SELECT pet.element_type_id,
1407: piv.input_value_id
1408: FROM pay_input_values_f piv,
1409: pay_element_types_f pet
1410: WHERE piv.element_type_id = pet.element_type_id
1411: AND pet.legislation_code = 'GB'
1412: AND pet.element_name = p_element_name
1413: AND piv.name = p_value_name;