APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay

141: pay_action_information pai, -- archived element/input value definition
142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
143: pay_assignment_actions paa, -- payroll run/quickpay action
144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
146: pay_input_values_f piv, -- "Pay values" of type Money
147: pay_run_results prr, -- run result created by the payroll run/quick pay
148: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
149: WHERE lck.locking_action_id = paa2.assignment_action_id

Line 302: FROM pay_element_types_f pet,

298:
299: CURSOR csr_element_type(p_element_type_id NUMBER,
300: p_effective_date DATE) IS
301: SELECT pet.formula_id
302: FROM pay_element_types_f pet,
303: ff_formulas_f fff
304: WHERE pet.element_type_id = p_element_type_id
305: AND pet.formula_id = fff.formula_id
306: AND fff.formula_name = 'ONCE_EACH_PERIOD'

Line 498: pay_element_types_f pet

494: pec.classification_name,
495: piv.uom
496: FROM pay_element_classifications pec,
497: pay_input_values_f piv,
498: pay_element_types_f pet
499: WHERE pec.classification_name IN
500: ('Court Orders',
501: 'Voluntary Deductions',
502: 'Pre-Tax Deductions',

Line 538: pay_element_types_f pet

534: 'Information',
535: piv.uom
536: FROM pay_element_classifications pec,
537: pay_input_values_f piv,
538: pay_element_types_f pet
539: WHERE pec.classification_name IN ( 'Information')
540: AND pec.business_group_id IS NULL
541: AND pec.legislation_code = 'IE'
542: AND pet.classification_id = pec.classification_id

Line 949: pay_element_types_f pet

945: p_value_name CHAR) IS
946: SELECT pet.element_type_id,
947: piv.input_value_id
948: FROM pay_input_values_f piv,
949: pay_element_types_f pet
950: WHERE piv.element_type_id = pet.element_type_id
951: AND pet.legislation_code = 'IE'
952: AND pet.element_name = p_element_name
953: AND piv.name = p_value_name;

Line 2022: pay_element_types_f pet

2018: p_value_name CHAR) IS
2019: SELECT pet.element_type_id,
2020: piv.input_value_id
2021: FROM pay_input_values_f piv,
2022: pay_element_types_f pet
2023: WHERE piv.element_type_id = pet.element_type_id
2024: AND pet.legislation_code = 'IE'
2025: AND pet.element_name = p_element_name
2026: AND piv.name = p_value_name;

Line 3157: pay_element_types_f pet

3153: p_value_name CHAR) IS
3154: SELECT pet.element_type_id,
3155: piv.input_value_id
3156: FROM pay_input_values_f piv,
3157: pay_element_types_f pet
3158: WHERE piv.element_type_id = pet.element_type_id
3159: AND pet.legislation_code = 'IE'
3160: AND pet.element_name = p_element_name
3161: AND piv.name = p_value_name;