APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 165: FROM pay_input_values_f piv

161:
162: CURSOR csr_input_value_uom(p_input_value_id NUMBER,
163: p_effective_date DATE) IS
164: SELECT piv.uom
165: FROM pay_input_values_f piv
166: WHERE piv.input_value_id = p_input_value_id
167: AND p_effective_date BETWEEN
168: piv.effective_start_date AND piv.effective_end_date;
169:

Line 382: pay_input_values_f piv,

378: NVL(pet.reporting_name,pet.element_name) element_name,
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

Line 604: FROM pay_input_values_f piv,

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

Line 991: ,pay_input_values_f piv

987: SELECT prrv.result_value reference
988: FROM pay_element_entries_f peef
989: ,pay_run_results prr
990: ,pay_run_result_values prrv
991: ,pay_input_values_f piv
992: WHERE peef.element_entry_id = p_element_entry_id
993: and piv.name ='Reference'
994: and piv.legislation_code='GB'
995: and peef.element_type_id = piv.element_type_id

Line 1408: FROM pay_input_values_f piv,

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