DBA Data[Home] [Help]

APPS.PAY_HK_IR56 dependencies on PAY_INPUT_VALUES_F

Line 107: pay_input_values_f piv

103: pay_element_entries_f pee,
104: pay_element_links_f pel,
105: pay_balance_types pbt,
106: pay_balance_feeds_f pbf,
107: pay_input_values_f piv
108: WHERE pee.assignment_id = p_assignment_id
109: AND pee.element_link_id = pel.element_link_id
110: AND pbf.balance_type_id = pbt.balance_type_id
111: AND pbf.input_value_id = piv.input_value_id

Line 152: pay_input_values_f pivf,

148: IS
149: SELECT COUNT(pivf.input_value_id)
150: FROM pay_element_entries_f pee,
151: pay_element_types_f pet,
152: pay_input_values_f pivf,
153: pay_balance_types pbt,
154: pay_balance_feeds_f pbf
155: WHERE pee.assignment_id = p_assignment_id
156: AND pee.entry_type = 'B'