APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 208: from pay_input_values_f piv

204: p_input_value_id number,
205: p_effective_date date
206: ) is
207: select piv.uom
208: from pay_input_values_f piv
209: where piv.input_value_id = p_input_value_id
210: and p_effective_date between piv.effective_start_date and piv.effective_end_date;
211:
212: l_index number := 1;

Line 395: pay_input_values_f piv,

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
399: pay_assignment_actions rpaa, -- Assignment Action of Run

Line 1040: from pay_input_values_f piv,

1036: p_element_name varchar2,
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

Line 1636: FROM pay_input_values_f piv,

1632: CURSOR csr_input_value_id(p_element_name CHAR,
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