APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 89: l_ele_name pay_element_types_f.element_name%TYPE;

85: l_ovn_eei NUMBER;
86: l_element_type_id NUMBER;
87: l_avcren VARCHAR2(80);
88: l_ele_obj_ver_number NUMBER; --
89: l_ele_name pay_element_types_f.element_name%TYPE;
90: l_name pay_input_values_f.name%TYPE;
91: i NUMBER;
92:
93: -- Extra Information variables

Line 191: FROM pay_element_types_f

187: AND (legislation_code = 'GB' OR legislation_code IS NULL);
188:
189: CURSOR c2_getele(lc_ele_name varchar2) IS
190: SELECT element_type_id
191: FROM pay_element_types_f
192: WHERE element_name = lc_ele_name
193: AND (business_group_id = p_bg_id OR business_group_id IS NULL)
194: AND (legislation_code = 'GB' OR legislation_code IS NULL);
195:

Line 198: FROM pay_element_types_f

194: AND (legislation_code = 'GB' OR legislation_code IS NULL);
195:
196: CURSOR c3_updele(lc_ele_type_id number) IS
197: SELECT rowid
198: FROM pay_element_types_f
199: WHERE element_type_id = lc_ele_type_id
200: FOR UPDATE NOWAIT;
201:
202: c1_rec c1_getfor%ROWTYPE;

Line 226: UPDATE pay_element_types_f

222:
223: FETCH c3_updele INTO c3_rec;
224: EXIT WHEN c3_updele%NOTFOUND;
225:
226: UPDATE pay_element_types_f
227: SET formula_id = c1_rec.formula_id
228: WHERE rowid = c3_rec.rowid;
229:
230: END LOOP;

Line 254: pay_element_types_f pet

250: SELECT input_value_id,
251: piv.name,
252: piv.element_type_id
253: FROM pay_input_values_f piv,
254: pay_element_types_f pet
255: WHERE element_name= lc_ele_name
256: AND piv.element_type_id=pet.element_type_id
257: AND (piv.business_group_id =p_bg_id OR piv.business_group_id IS NULL)
258: AND piv.name =lc_name

Line 313: FROM pay_element_types_f

309: l_proc varchar2(60) := 'pqp_gb_pensions_template.get_object_id';
310: --
311: CURSOR c2 (c_object_name varchar2) is
312: SELECT element_type_id
313: FROM pay_element_types_f
314: WHERE element_name = c_object_name
315: AND business_group_id = p_bg_id;
316: --
317: CURSOR c3 (c_object_name in varchar2) is