eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_TAX_CREDIT_PKG dependencies on PAY_INPUT_VALUES_F

Line 14: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;

10: FUNCTION Get_Input_Value_Id(
11: p_name in VARCHAR2,
12: p_effective_date in DATE
13: ) RETURN NUMBER is
14: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;
15:
16: BEGIN
17:
18: SELECT ipv.input_value_id INTO l_input_value_id

Line 19: FROM PAY_INPUT_VALUES_F ipv,

15:
16: BEGIN
17:
18: SELECT ipv.input_value_id INTO l_input_value_id
19: FROM PAY_INPUT_VALUES_F ipv,
20: PAY_ELEMENT_TYPES_F ele
21: WHERE ele.element_name = 'Tax Credit'
22: AND ipv.name = p_name
23: AND ele.element_type_id = ipv.element_type_id

Line 96: pay_input_values_f ipv1,

92: FROM pay_element_entry_values_f eev1,
93: pay_element_entry_values_f eev2,
94: pay_element_entry_values_f eev3,
95: pay_element_entries_f ent,
96: pay_input_values_f ipv1,
97: pay_input_values_f ipv2,
98: pay_input_values_f ipv3,
99: pay_element_links_f lnk,
100: pay_element_types_f ele

Line 97: pay_input_values_f ipv2,

93: pay_element_entry_values_f eev2,
94: pay_element_entry_values_f eev3,
95: pay_element_entries_f ent,
96: pay_input_values_f ipv1,
97: pay_input_values_f ipv2,
98: pay_input_values_f ipv3,
99: pay_element_links_f lnk,
100: pay_element_types_f ele
101: where ele.element_name = p_ele

Line 98: pay_input_values_f ipv3,

94: pay_element_entry_values_f eev3,
95: pay_element_entries_f ent,
96: pay_input_values_f ipv1,
97: pay_input_values_f ipv2,
98: pay_input_values_f ipv3,
99: pay_element_links_f lnk,
100: pay_element_types_f ele
101: where ele.element_name = p_ele
102: and ele.element_type_id = lnk.element_type_id

Line 152: pay_input_values_f ipv1,

148: Select 'Y'
149: FROM pay_element_entry_values_f eev1,
150: pay_element_entry_values_f eev2,
151: pay_element_entries_f ent,
152: pay_input_values_f ipv1,
153: pay_input_values_f ipv2,
154: pay_element_links_f lnk,
155: pay_element_types_f ele
156: where ele.element_name = p_ele

Line 153: pay_input_values_f ipv2,

149: FROM pay_element_entry_values_f eev1,
150: pay_element_entry_values_f eev2,
151: pay_element_entries_f ent,
152: pay_input_values_f ipv1,
153: pay_input_values_f ipv2,
154: pay_element_links_f lnk,
155: pay_element_types_f ele
156: where ele.element_name = p_ele
157: and ele.element_type_id = lnk.element_type_id

Line 183: pay_input_values_f ipv1,

179: FROM pay_element_entry_values_f eev1,
180: pay_element_entry_values_f eev2,
181: pay_element_entry_values_f eev3,
182: pay_element_entries_f ent,
183: pay_input_values_f ipv1,
184: pay_input_values_f ipv2,
185: pay_input_values_f ipv3,
186: pay_element_links_f lnk,
187: pay_element_types_f ele

Line 184: pay_input_values_f ipv2,

180: pay_element_entry_values_f eev2,
181: pay_element_entry_values_f eev3,
182: pay_element_entries_f ent,
183: pay_input_values_f ipv1,
184: pay_input_values_f ipv2,
185: pay_input_values_f ipv3,
186: pay_element_links_f lnk,
187: pay_element_types_f ele
188: where ele.element_name = p_ele

Line 185: pay_input_values_f ipv3,

181: pay_element_entry_values_f eev3,
182: pay_element_entries_f ent,
183: pay_input_values_f ipv1,
184: pay_input_values_f ipv2,
185: pay_input_values_f ipv3,
186: pay_element_links_f lnk,
187: pay_element_types_f ele
188: where ele.element_name = p_ele
189: and ele.element_type_id = lnk.element_type_id

Line 220: pay_input_values_f ipv1,

216: Select 'Y'
217: FROM pay_element_entry_values_f eev1,
218: pay_element_entry_values_f eev2,
219: pay_element_entries_f ent,
220: pay_input_values_f ipv1,
221: pay_input_values_f ipv2,
222: pay_element_links_f lnk,
223: pay_element_types_f ele
224: where ele.element_name = p_ele

Line 221: pay_input_values_f ipv2,

217: FROM pay_element_entry_values_f eev1,
218: pay_element_entry_values_f eev2,
219: pay_element_entries_f ent,
220: pay_input_values_f ipv1,
221: pay_input_values_f ipv2,
222: pay_element_links_f lnk,
223: pay_element_types_f ele
224: where ele.element_name = p_ele
225: and ele.element_type_id = lnk.element_type_id

Line 452: pay_input_values_f ipv1,

448: FROM pay_element_entry_values_f eev1,
449: pay_element_entry_values_f eev2,
450: pay_element_entry_values_f eev3,
451: pay_element_entries_f ent,
452: pay_input_values_f ipv1,
453: pay_input_values_f ipv2,
454: pay_input_values_f ipv3,
455: pay_element_links_f lnk,
456: pay_element_types_f ele

Line 453: pay_input_values_f ipv2,

449: pay_element_entry_values_f eev2,
450: pay_element_entry_values_f eev3,
451: pay_element_entries_f ent,
452: pay_input_values_f ipv1,
453: pay_input_values_f ipv2,
454: pay_input_values_f ipv3,
455: pay_element_links_f lnk,
456: pay_element_types_f ele
457: where ele.element_name = p_ele

Line 454: pay_input_values_f ipv3,

450: pay_element_entry_values_f eev3,
451: pay_element_entries_f ent,
452: pay_input_values_f ipv1,
453: pay_input_values_f ipv2,
454: pay_input_values_f ipv3,
455: pay_element_links_f lnk,
456: pay_element_types_f ele
457: where ele.element_name = p_ele
458: and ele.element_type_id = lnk.element_type_id