APPS.PAY_DB_PAY_US_GROSS dependencies on PAY_ELEMENT_TYPES_F

Line 108: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

104: p_business_group_id IN NUMBER,
105: p_element_name IN VARCHAR2
106: ) IS
107: -- Local Variables
108: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
109: --
110: CURSOR elements IS
111: SELECT pet.element_name,
112: pet.element_type_id,

Line 116: FROM pay_element_types_f pet,

112: pet.element_type_id,
113: processing_priority,
114: element_information10,
115: element_information12
116: FROM pay_element_types_f pet,
117: per_business_groups pbg
118: WHERE pbg.business_group_id + 0 = pet.business_group_id + 0
119: AND pbg.business_group_id + 0 = p_business_group_id
120: AND pet.element_name like v_element_name;

Line 174: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

170: v_element_type_ID NUMBER;
171: v_prev_proc_rule_ID NUMBER;
172: v_result_rule_ID NUMBER;
173: v_formula_ID NUMBER;
174: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
175: v_input_value_ID NUMBER;
176: v_start_date DATE;
177: v_end_date DATE;
178: v_piv_name PAY_INPUT_VALUES_F.NAME%TYPE;

Line 210: FROM pay_element_types_f_tl type_tl,

206: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 2);
207: --
208: SELECT type.element_type_id
209: INTO v_element_type_id
210: FROM pay_element_types_f_tl type_tl,
211: pay_element_types_f type
212: WHERE type_tl.element_type_id = type.element_type_id
213: and userenv('LANG') = type_tl.language
214: AND nvl(business_group_id, -1) = nvl(g_business_group_ID, -1)

Line 211: pay_element_types_f type

207: --
208: SELECT type.element_type_id
209: INTO v_element_type_id
210: FROM pay_element_types_f_tl type_tl,
211: pay_element_types_f type
212: WHERE type_tl.element_type_id = type.element_type_id
213: and userenv('LANG') = type_tl.language
214: AND nvl(business_group_id, -1) = nvl(g_business_group_ID, -1)
215: AND type_tl.element_name = p_element_name;

Line 280: pay_element_types_f_tl pet_tl,

276: SELECT piv.input_value_id
277: INTO v_input_value_ID
278: FROM pay_input_values_f_tl piv_tl,
279: pay_input_values_f piv,
280: pay_element_types_f_tl pet_tl,
281: pay_element_types_f pet
282: WHERE piv_tl.input_value_id = piv.input_value_id
283: and pet_tl.element_type_id = pet.element_type_id
284: and userenv('LANG') = piv_tl.language

Line 281: pay_element_types_f pet

277: INTO v_input_value_ID
278: FROM pay_input_values_f_tl piv_tl,
279: pay_input_values_f piv,
280: pay_element_types_f_tl pet_tl,
281: pay_element_types_f pet
282: WHERE piv_tl.input_value_id = piv.input_value_id
283: and pet_tl.element_type_id = pet.element_type_id
284: and userenv('LANG') = piv_tl.language
285: and userenv('LANG') = pet_tl.language

Line 313: pay_element_types_f pet

309: SELECT piv.input_value_id
310: INTO v_input_value_ID
311: FROM pay_input_values_f_tl piv_tl,
312: pay_input_values_f piv,
313: pay_element_types_f pet
314: WHERE piv_tl.input_value_id = piv.input_value_id
315: and userenv('LANG') = piv_tl.language
316: and piv_tl.name = v_piv_name
317: AND piv.business_group_id is null

Line 366: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

362: ) RETURN NUMBER IS
363: -- Local Variables
364: v_formula_ID NUMBER;
365: v_element_type_ID NUMBER;
366: v_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
367: v_priority_incr NUMBER;
368: v_classification VARCHAR2(80);
369: v_post_termination VARCHAR2(80);
370: v_description VARCHAR2(240);