APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_INPUT_VALUES_F

Line 2248: FROM pay_input_values_f pivf,

2244: CURSOR c_ele_entry_jd(cp_element_type_id NUMBER,
2245: cp_element_entry_id NUMBER)
2246: IS
2247: SELECT peevf.screen_entry_value
2248: FROM pay_input_values_f pivf,
2249: pay_element_entry_values_f peevf
2250: WHERE pivf.element_type_id = cp_element_type_id
2251: AND pivf.name = 'Jurisdiction'
2252: AND peevf.element_entry_id = cp_element_entry_id

Line 4593: pay_input_values_f piv

4589: ,cp_effective_date DATE)
4590: IS
4591: SELECT ppb.name
4592: FROM per_pay_bases ppb,
4593: pay_input_values_f piv
4594: WHERE ppb.pay_basis_id = cp_pay_basis_id
4595: AND piv.input_value_id = ppb.input_value_id
4596: AND cp_effective_date BETWEEN piv.effective_start_date
4597: AND piv.effective_end_date;

Line 4806: pay_input_values_f piv,

4802: FROM pay_element_type_extra_info eit,
4803: pay_element_types_f pet,
4804: pay_element_types_f_tl petl,
4805: pay_element_classifications pec,
4806: pay_input_values_f piv,
4807: pay_input_values_f_tl pivtl,
4808: pay_element_links_f pel
4809: WHERE eit.information_type = 'SIMULATION_ELEMENTS'
4810: AND eit.eei_information1 = 'Y'

Line 4807: pay_input_values_f_tl pivtl,

4803: pay_element_types_f pet,
4804: pay_element_types_f_tl petl,
4805: pay_element_classifications pec,
4806: pay_input_values_f piv,
4807: pay_input_values_f_tl pivtl,
4808: pay_element_links_f pel
4809: WHERE eit.information_type = 'SIMULATION_ELEMENTS'
4810: AND eit.eei_information1 = 'Y'
4811: AND eit.element_type_id = pet.element_type_id

Line 4892: pay_input_values_f piv1

4888: ( pel.pay_basis_id IS NULL
4889: AND NOT EXISTS
4890: (SELECT ppb.pay_basis_id
4891: FROM per_pay_bases ppb,
4892: pay_input_values_f piv1
4893: WHERE piv1.element_type_id = pet.element_type_id
4894: AND ld_effective_date
4895: BETWEEN piv1.effective_start_date
4896: AND piv1.effective_end_date