APPS.PAY_GB_TAX_CREDIT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 20: PAY_ELEMENT_TYPES_F ele

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
24: AND p_effective_date between ele.effective_start_date

Line 52: l_element_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

48: from pay_element_types
49: where element_name = 'Tax Credit';
50:
51: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;
52: l_element_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
53: l_create_warning BOOLEAN;
54: l_effective_date DATE;
55:
56: BEGIN

Line 100: pay_element_types_f ele

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
103: and ent.element_link_id = lnk.element_link_id
104: and ent.assignment_id = p_asg

Line 155: pay_element_types_f ele

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
158: and ent.element_link_id = lnk.element_link_id
159: and ent.assignment_id = p_asg

Line 187: pay_element_types_f ele

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
190: and ent.element_link_id = lnk.element_link_id
191: and ent.assignment_id = p_asg

Line 223: pay_element_types_f ele

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
226: and ent.element_link_id = lnk.element_link_id
227: and ent.assignment_id = p_asg

Line 438: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,

434: PROCEDURE Check_End_Or_Stop_Date(p_assignment_id in PAY_ELEMENT_ENTRIES_F.assignment_id%TYPE,
435: p_element_entry_id in PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE,
436: p_end_date in DATE,
437: p_start_date in DATE,
438: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
439: p_message out nocopy VARCHAR2) is
440:
441: CURSOR c_end_after_start_date(p_asg in NUMBER,
442: p_element_entry_id in NUMBER,

Line 456: pay_element_types_f ele

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
459: and ent.element_link_id = lnk.element_link_id
460: and ent.assignment_id = p_asg

Line 691: pay_element_types_f ele

687: p_ent_id in NUMBER) is
688: select prr.assignment_action_id,
689: prr.source_id
690: from pay_run_results prr,
691: pay_element_types_f ele
692: where prr.assignment_action_id in (
693: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||
694: paa.assignment_action_id),16))
695: FROM pay_assignment_actions paa,

Line 715: pay_element_types_f ele

711: p_ent in NUMBER) is
712: select prr.assignment_action_id,
713: prr.source_id
714: from pay_run_results prr,
715: pay_element_types_f ele
716: where prr.assignment_action_id in (
717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
718: paa.assignment_action_id),16))
719: from pay_assignment_actions paa,