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_T1_PENSION_EXTRACTS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 26: g_criteria_location_code pay_user_column_instances_f.value%type;--8996926

22: g_pension_year_start_date DATE;
23: g_pension_year_end_date DATE;
24:
25: g_extract_udt_name VARCHAR2(80);
26: g_criteria_location_code pay_user_column_instances_f.value%type;--8996926
27: g_lea_number VARCHAR2(3):=RPAD(' ',3,' ');
28: g_crossbg_enabled VARCHAR2(1) := 'N';
29: g_cross_per_enabled VARCHAR2(1);
30: g_estb_number VARCHAR2(4):='0000';

Line 37: g_oth_rate_type pay_user_column_instances_f.value%type;

33:
34: g_reporting_mode VARCHAR2(10);
35: g_trace VARCHAR2(1) := NULL;
36:
37: g_oth_rate_type pay_user_column_instances_f.value%type;
38: g_sal_rate_type pay_user_column_instances_f.value%type;
39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;

Line 38: g_sal_rate_type pay_user_column_instances_f.value%type;

34: g_reporting_mode VARCHAR2(10);
35: g_trace VARCHAR2(1) := NULL;
36:
37: g_oth_rate_type pay_user_column_instances_f.value%type;
38: g_sal_rate_type pay_user_column_instances_f.value%type;
39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;

Line 39: g_sf_rate_type pay_user_column_instances_f.value%type;

35: g_trace VARCHAR2(1) := NULL;
36:
37: g_oth_rate_type pay_user_column_instances_f.value%type;
38: g_sal_rate_type pay_user_column_instances_f.value%type;
39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;

Line 40: g_lon_rate_type pay_user_column_instances_f.value%type;

36:
37: g_oth_rate_type pay_user_column_instances_f.value%type;
38: g_sal_rate_type pay_user_column_instances_f.value%type;
39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;

Line 602: matrix_value pay_user_column_instances_f.value%TYPE,

598:
599: Type t_udt_rec Is record (
600: column_name pay_user_columns.user_column_name%TYPE,
601: row_name pay_user_rows_f.row_low_range_or_name%TYPE,
602: matrix_value pay_user_column_instances_f.value%TYPE,
603: start_date date,
604: end_date date);
605: --
606:

Line 1204: ,pay_user_column_instances_f pci

1200: ,pci.user_column_instance_id
1201: from pay_user_tables put
1202: ,pay_user_columns puc
1203: ,pay_user_rows_f pur
1204: ,pay_user_column_instances_f pci
1205: where put.user_table_name = c_user_table_name
1206: and puc.user_table_id = put.user_table_id
1207: and puc.user_column_name = c_user_column_name
1208: and pur.row_low_range_or_name = c_user_row_name