DBA Data[Home] [Help]

APPS.CN_PAYRUN_PVT dependencies on PAY_ELEMENT_TYPES_F

Line 277: pay_element_types_f pet,

273: cn_quota_pay_elements qpe,
274: cn_payruns p,
275: cn_objects tab,
276: cn_objects col,
277: pay_element_types_f pet,
278: pay_input_values_f piv
279: WHERE qpe.pay_element_type_id = p_element_type_id
280: AND qpe.quota_id = decode(p_incentive_type_code,
281: 'PMTPLN_REC' , -1001,

Line 307: pay_element_types_f pet,

303: piv.input_value_id element_input_id,
304: piv.uom uom, piv.name element_input_name
305: FROM
306: pay_input_values_f piv,
307: pay_element_types_f pet,
308: cn_quota_pay_elements qpe,
309: cn_payruns p
310: WHERE qpe.pay_element_type_id = p_element_type_id
311: AND qpe.quota_id = decode(p_incentive_type_code,

Line 333: from pay_element_types_f

329:
330:
331: Cursor get_element_name ( p_element_type_id IN NUMBER ) IS
332: Select element_name
333: from pay_element_types_f
334: where element_type_id = p_element_type_id ;
335:
336: --
337: -- Cursor

Line 385: l_element_name pay_element_types_f.element_name%type;

381:
382: l_batch_id NUMBER;
383: l_object_version_number NUMBER;
384: l_batch_line_id NUMBER;
385: l_element_name pay_element_types_f.element_name%type;
386:
387: l_mask varchar2(100) ;
388:
389: CURSOR cn_repositories_cur IS