APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 1263: from pay_user_column_instances_f

1259:
1260: Cursor Get_Matrix_Value ( c_user_column_id in number
1261: ,c_user_row_id in number ) Is
1262: Select value, effective_start_date, effective_end_date
1263: from pay_user_column_instances_f
1264: where user_column_id = c_user_column_id
1265: and user_row_id = c_user_row_id
1266: and ((business_group_id is null and legislation_code is null)
1267: or (legislation_code is not null

Line 1278: l_matrix_value pay_user_column_instances_f.value%TYPE;

1274: -- This has been declared in the pkg header as global collection
1275: -- g_udt_rec t_udt_array;
1276: l_user_column_name pay_user_columns.user_column_name%TYPE;
1277: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
1278: l_matrix_value pay_user_column_instances_f.value%TYPE;
1279: l_user_table_id pay_user_tables.user_table_id%TYPE;
1280: l_user_column_id pay_user_columns.user_column_id%TYPE;
1281: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
1282: l_idx number;

Line 1753: ,pay_user_column_instances_f pci

1749: ,pci.value
1750: from pay_user_tables put
1751: ,pay_user_columns puc
1752: ,pay_user_rows_f pur
1753: ,pay_user_column_instances_f pci
1754: where put.user_table_name = c_user_table_name
1755: and puc.user_table_id = put.user_table_id
1756: and puc.user_column_name = c_user_column_name
1757: and pur.row_low_range_or_name = c_user_row_name

Line 1774: l_return_value pay_user_column_instances_f.value%TYPE;

1770: )
1771: order by put.user_table_name, puc.user_column_name, pur.display_sequence;
1772: */
1773:
1774: l_return_value pay_user_column_instances_f.value%TYPE;
1775: l_udt_row Get_Matrix_Value%ROWTYPE;
1776: l_notfound_UDTCache Boolean;
1777: l_effective_date date;
1778: l_table_name pay_user_tables.user_table_name%TYPE;

Line 5781: ,pay_user_column_instances_f asgv

5777: From pay_user_tables tbls
5778: ,pay_user_columns asgc
5779: ,pay_user_columns extc
5780: ,pay_user_rows_f urws
5781: ,pay_user_column_instances_f asgv
5782: ,pay_user_column_instances_f extv
5783: where tbls.user_table_name ='PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'
5784: and asgc.user_table_id = tbls.user_table_id
5785: and extc.user_table_id = tbls.user_table_id

Line 5782: ,pay_user_column_instances_f extv

5778: ,pay_user_columns asgc
5779: ,pay_user_columns extc
5780: ,pay_user_rows_f urws
5781: ,pay_user_column_instances_f asgv
5782: ,pay_user_column_instances_f extv
5783: where tbls.user_table_name ='PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'
5784: and asgc.user_table_id = tbls.user_table_id
5785: and extc.user_table_id = tbls.user_table_id
5786: and asgc.user_column_name = 'Assignment Employment Category Lookup Code'

Line 17110: l_user_value pay_user_column_instances_f.value%TYPE;

17106: l_udt_name pay_user_tables.user_table_name%TYPE :=
17107: 'PQP_GB_TP_TYPE1_EXTRACT_DEFINITIONS';
17108: l_return NUMBER;
17109: l_udt_id NUMBER;
17110: l_user_value pay_user_column_instances_f.value%TYPE;
17111: l_error_msg VARCHAR2(2000);
17112:
17113: -- RET1.a : new variables to store element_type_extra_info_id
17114: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;