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 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 599: matrix_value pay_user_column_instances_f.value%TYPE,

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

Line 1183: ,pay_user_column_instances_f pci

1179: ,pci.user_column_instance_id
1180: from pay_user_tables put
1181: ,pay_user_columns puc
1182: ,pay_user_rows_f pur
1183: ,pay_user_column_instances_f pci
1184: where put.user_table_name = c_user_table_name
1185: and puc.user_table_id = put.user_table_id
1186: and puc.user_column_name = c_user_column_name
1187: and pur.row_low_range_or_name = c_user_row_name