APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 1262: from pay_user_column_instances_f

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

Line 1277: l_matrix_value pay_user_column_instances_f.value%TYPE;

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

Line 1752: ,pay_user_column_instances_f pci

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

Line 1773: l_return_value pay_user_column_instances_f.value%TYPE;

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

Line 5809: ,pay_user_column_instances_f asgv

5805: From pay_user_tables tbls
5806: ,pay_user_columns asgc
5807: ,pay_user_columns extc
5808: ,pay_user_rows_f urws
5809: ,pay_user_column_instances_f asgv
5810: ,pay_user_column_instances_f extv
5811: where tbls.user_table_name ='PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'
5812: and asgc.user_table_id = tbls.user_table_id
5813: and extc.user_table_id = tbls.user_table_id

Line 5810: ,pay_user_column_instances_f extv

5806: ,pay_user_columns asgc
5807: ,pay_user_columns extc
5808: ,pay_user_rows_f urws
5809: ,pay_user_column_instances_f asgv
5810: ,pay_user_column_instances_f extv
5811: where tbls.user_table_name ='PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'
5812: and asgc.user_table_id = tbls.user_table_id
5813: and extc.user_table_id = tbls.user_table_id
5814: and asgc.user_column_name = 'Assignment Employment Category Lookup Code'

Line 17479: l_user_value pay_user_column_instances_f.value%TYPE;

17475: l_udt_name pay_user_tables.user_table_name%TYPE :=
17476: 'PQP_GB_TP_TYPE1_EXTRACT_DEFINITIONS';
17477: l_return NUMBER;
17478: l_udt_id NUMBER;
17479: l_user_value pay_user_column_instances_f.value%TYPE;
17480: l_error_msg VARCHAR2(2000);
17481:
17482: -- RET1.a : new variables to store element_type_extra_info_id
17483: l_element_type_extra_info_id pay_element_type_extra_info.element_type_extra_info_id%type;