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.CN_PAY_ELEMENT_INPUTS_PVT dependencies on CN_OBJECTS

Line 28: FROM cn_objects

24:
25: IF p_object_type = 'COL' THEN
26:
27: SELECT object_id, NAME INTO x_object_id, x_tab_col_name
28: FROM cn_objects
29: WHERE user_name = p_object_name
30: AND object_type = p_object_type
31: AND table_id = p_table_id;
32:

Line 36: FROM cn_objects

32:
33: ELSE
34:
35: SELECT object_id, name INTO x_object_id, x_tab_col_name
36: FROM cn_objects
37: WHERE user_name = p_object_name
38: AND object_type = p_object_type
39: AND name IN ( 'CN_PAYMENT_TRANSACTIONS', 'CN_PAYRUNS', 'CN_SALESREPS');
40: END IF;

Line 282: l_table_name cn_objects.name%TYPE;

278:
279: l_pay_element_input_rec pay_element_input_rec_type := G_MISS_PAY_ELEMENT_INPUT_REC;
280: l_action VARCHAR2(30) := 'CREATE';
281:
282: l_table_name cn_objects.name%TYPE;
283: l_column_name cn_objects.name%TYPE;
284:
285:
286: BEGIN

Line 283: l_column_name cn_objects.name%TYPE;

279: l_pay_element_input_rec pay_element_input_rec_type := G_MISS_PAY_ELEMENT_INPUT_REC;
280: l_action VARCHAR2(30) := 'CREATE';
281:
282: l_table_name cn_objects.name%TYPE;
283: l_column_name cn_objects.name%TYPE;
284:
285:
286: BEGIN
287: x_pay_element_input_id := 0;

Line 463: l_column_name cn_objects.name%TYPE;

459:
460: l_pay_element_input_rec pay_element_input_rec_type := G_MISS_PAY_ELEMENT_INPUT_REC ;
461: l_action VARCHAR2(30) := 'UPDATE';
462:
463: l_column_name cn_objects.name%TYPE;
464: l_table_name cn_objects.name%TYPE;
465:
466: BEGIN
467:

Line 464: l_table_name cn_objects.name%TYPE;

460: l_pay_element_input_rec pay_element_input_rec_type := G_MISS_PAY_ELEMENT_INPUT_REC ;
461: l_action VARCHAR2(30) := 'UPDATE';
462:
463: l_column_name cn_objects.name%TYPE;
464: l_table_name cn_objects.name%TYPE;
465:
466: BEGIN
467:
468: -- Standard Start of API savepoint

Line 777: l_table_name cn_objects_all.name%TYPE;

773:
774: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
775: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;
780: l_pay_input_name pay_input_values_f.name%TYPE;
781: l_line_number cn_pay_element_inputs.line_number%TYPE;

Line 778: l_column_name cn_objects_all.name%TYPE;

774: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
775: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;
780: l_pay_input_name pay_input_values_f.name%TYPE;
781: l_line_number cn_pay_element_inputs.line_number%TYPE;
782: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;

Line 797: cn_objects ct,

793: FROM cn_pay_element_inputs cpei,
794: cn_quota_pay_elements cqpe,
795: pay_input_values_f piv,
796: pay_element_types_f pet,
797: cn_objects ct,
798: cn_objects cc,
799: gl_sets_of_books glsob,
800: cn_repositories cnr
801: where

Line 798: cn_objects cc,

794: cn_quota_pay_elements cqpe,
795: pay_input_values_f piv,
796: pay_element_types_f pet,
797: cn_objects ct,
798: cn_objects cc,
799: gl_sets_of_books glsob,
800: cn_repositories cnr
801: where
802: cnr.set_of_books_id = glsob.set_of_books_id