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.PQP_GB_TP_PENSION_EXTRACTS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 178: l_udt_value pay_user_column_instances_f.value%type;

174: ,p_udt_row_name VARCHAR2
175: ,p_effective_date DATE
176: ) RETURN VARCHAR2 -- row value
177: IS
178: l_udt_value pay_user_column_instances_f.value%type;
179: l_proc_name VARCHAR2(61):= 'get_extract_udt_info';
180: BEGIN
181: debug_enter(l_proc_name);
182:

Line 315: ,pay_user_column_instances_f asgv

311: FROM pay_user_tables tbls
312: ,pay_user_columns asgc
313: ,pay_user_columns extc
314: ,pay_user_rows_f urws
315: ,pay_user_column_instances_f asgv
316: ,pay_user_column_instances_f extv
317: WHERE tbls.user_table_name =
318: 'PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'
319: AND asgc.user_table_id = tbls.user_table_id

Line 316: ,pay_user_column_instances_f extv

312: ,pay_user_columns asgc
313: ,pay_user_columns extc
314: ,pay_user_rows_f urws
315: ,pay_user_column_instances_f asgv
316: ,pay_user_column_instances_f extv
317: WHERE tbls.user_table_name =
318: 'PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'
319: AND asgc.user_table_id = tbls.user_table_id
320: AND extc.user_table_id = tbls.user_table_id

Line 631: l_user_value pay_user_column_instances_f.value%TYPE;

627: l_proc_name VARCHAR2 (80) := g_proc_name
628: || 'get_allow_ele_info';
629: l_proc_step NUMBER;
630: l_return NUMBER;
631: l_user_value pay_user_column_instances_f.value%TYPE;
632: l_error_msg VARCHAR2(2000);
633: l_element_type_id NUMBER := NULL;
634:
635: --

Line 726: l_user_value pay_user_column_instances_f.value%TYPE;

722: := g_proc_name
723: || 'get_allow_rt_ele_info';
724: l_proc_step NUMBER;
725: l_return NUMBER;
726: l_user_value pay_user_column_instances_f.value%TYPE;
727: l_error_msg VARCHAR2(2000);
728: l_element_type_id NUMBER := NULL;
729: l_tab_allowance_eles t_allowance_eles := p_tab_aln_eles;
730:

Line 911: l_user_value pay_user_column_instances_f.value%TYPE;

907: l_udt_name pay_user_tables.user_table_name%TYPE :=
908: 'PQP_GB_TP_ALLOWANCE_ELEMENTS_MAPPING_TABLE';
909: l_return NUMBER;
910: l_udt_id NUMBER;
911: l_user_value pay_user_column_instances_f.value%TYPE;
912: l_error_msg VARCHAR2(2000);
913:
914: -- RET1.a : new variables to store element_type_extra_info_id
915: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;

Line 2567: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)

2563: l_busnsgrp_id NUMBER;
2564:
2565: -- QA failed due to length 30 increased to 100
2566: -- Max length based on the highest possible length of all its sources
2567: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2568: -- PER_QUALIFICATIONS_V NAME NOT NULL VARCHAR2(100)
2569: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)
2570: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2571: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)

Line 2573: l_attr_location_type pay_user_column_instances_f.value%type;

2569: -- PER_QUALIFICATIONS_V PROFESSIONAL_BODY_NAME VARCHAR2(80)
2570: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2571: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2572:
2573: l_attr_location_type pay_user_column_instances_f.value%type;
2574: -- Attribute Location Type
2575: l_flexfield_name pay_user_column_instances_f.value%type;
2576: -- Flexfield Name
2577: l_column_name pay_user_column_instances_f.value%type;

Line 2575: l_flexfield_name pay_user_column_instances_f.value%type;

2571: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2572:
2573: l_attr_location_type pay_user_column_instances_f.value%type;
2574: -- Attribute Location Type
2575: l_flexfield_name pay_user_column_instances_f.value%type;
2576: -- Flexfield Name
2577: l_column_name pay_user_column_instances_f.value%type;
2578: -- Flexfield Segment Name
2579:

Line 2577: l_column_name pay_user_column_instances_f.value%type;

2573: l_attr_location_type pay_user_column_instances_f.value%type;
2574: -- Attribute Location Type
2575: l_flexfield_name pay_user_column_instances_f.value%type;
2576: -- Flexfield Name
2577: l_column_name pay_user_column_instances_f.value%type;
2578: -- Flexfield Segment Name
2579:
2580: l_dfee_refno per_all_assignments_f.ass_attribute1%type;
2581: -- Max length based on the highest possible length of all its sources

Line 2842: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)

2838: l_teacher_start_date DATE; -- Teacher Start Date
2839:
2840: -- QA failed due to length 30 increased to 100
2841: -- Max length based on the highest possible length of all its sources
2842: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2843: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2844: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2845:
2846: l_flexfield_name pay_user_column_instances_f.value%type;

Line 2846: l_flexfield_name pay_user_column_instances_f.value%type;

2842: -- PAY_USER_COLUMN_INSTANCES_F VALUE VARCHAR2(80)
2843: -- FND_DESCRIPTIVE_FLEXS_VL DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2(40)
2844: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2845:
2846: l_flexfield_name pay_user_column_instances_f.value%type;
2847: -- Flexfield Name
2848: l_segment_name pay_user_column_instances_f.value%type;
2849: -- Flexfield Segment Name
2850:

Line 2848: l_segment_name pay_user_column_instances_f.value%type;

2844: -- ALL_TAB_COLUMNS COLUMN_NAME VARCHAR2(30)
2845:
2846: l_flexfield_name pay_user_column_instances_f.value%type;
2847: -- Flexfield Name
2848: l_segment_name pay_user_column_instances_f.value%type;
2849: -- Flexfield Segment Name
2850:
2851: l_ret_salary_scale per_grade_definitions.segment1%type;
2852: -- Salary Scale Return Value

Line 4193: l_user_value pay_user_column_instances_f.value%TYPE;

4189: := g_proc_name
4190: || 'get_allow_code_rt_ele_info';
4191: l_proc_step NUMBER;
4192: l_return NUMBER;
4193: l_user_value pay_user_column_instances_f.value%TYPE;
4194: l_error_msg VARCHAR2(2000);
4195: l_element_type_id NUMBER := NULL;
4196: l_tab_allowance_eles pqp_gb_t1_pension_extracts.t_allowance_eles := p_tab_aln_eles;
4197: