APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 184: from pay_element_types_f pet,

180: p_element_type_id number,
181: p_effective_date date
182: ) is
183: select pet.formula_id
184: from pay_element_types_f pet,
185: ff_formulas_f fff
186: where pet.element_type_id = p_element_type_id
187: and pet.formula_id = fff.formula_id
188: and fff.formula_name = 'ONCE_EACH_PERIOD'

Line 198: from pay_element_types_f pet

194: (p_element_type_id number,
195: p_effective_date date
196: ) is
197: select once_each_period_flag
198: from pay_element_types_f pet
199: where pet.element_type_id = p_element_type_id
200: and p_effective_date between pet.effective_start_date and pet.effective_end_date;
201:
202: cursor csr_input_value_uom

Line 394: from pay_element_types_f pet,

390: piv.input_value_id,
391: nvl(pet.reporting_name, pet.element_name) element_name,
392: pec.classification_name,
393: piv.uom
394: from pay_element_types_f pet,
395: pay_input_values_f piv,
396: pay_run_results prr,
397: pay_element_classifications pec,
398: pay_assignment_actions paa, -- Assignment Action of Prepayments

Line 1041: pay_element_types_f pet

1037: p_value_name varchar2
1038: ) is
1039: select piv.input_value_id
1040: from pay_input_values_f piv,
1041: pay_element_types_f pet
1042: where piv.element_type_id = pet.element_type_id
1043: and pet.legislation_code = 'ZA'
1044: and pet.element_name = p_element_name
1045: and piv.name = p_value_name;

Line 1637: pay_element_types_f pet

1633: p_value_name CHAR) IS
1634: SELECT pet.element_type_id,
1635: piv.input_value_id
1636: FROM pay_input_values_f piv,
1637: pay_element_types_f pet
1638: WHERE piv.element_type_id = pet.element_type_id
1639: AND pet.legislation_code = 'ZA'
1640: AND pet.element_name = p_element_name
1641: AND piv.name = p_value_name;