APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 209: from pay_input_values_f piv

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

Line 406: pay_input_values_f piv,

402: nvl(pet.reporting_name, pet.element_name) element_name,
403: pec.classification_name,
404: piv.uom
405: from pay_element_types_f pet,
406: pay_input_values_f piv,
407: pay_run_results prr,
408: pay_element_classifications pec,
409: pay_assignment_actions paa, -- Assignment Action of Prepayments
410: pay_assignment_actions rpaa, -- Assignment Action of Run

Line 1170: from pay_input_values_f piv,

1166: p_element_name varchar2,
1167: p_value_name varchar2
1168: ) is
1169: select piv.input_value_id
1170: from pay_input_values_f piv,
1171: pay_element_types_f pet
1172: where piv.element_type_id = pet.element_type_id
1173: and pet.legislation_code = 'ZA'
1174: and pet.element_name = p_element_name

Line 1890: FROM pay_input_values_f piv,

1886: CURSOR csr_input_value_id(p_element_name CHAR,
1887: p_value_name CHAR) IS
1888: SELECT pet.element_type_id,
1889: piv.input_value_id
1890: FROM pay_input_values_f piv,
1891: pay_element_types_f pet
1892: WHERE piv.element_type_id = pet.element_type_id
1893: AND pet.legislation_code = 'ZA'
1894: AND pet.element_name = p_element_name