APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_USER_TABLES

Line 1224: from pay_user_tables tbls

1220: ,p_effective_date in date ) Is
1221:
1222: Cursor Get_table_id ( c_udt_name in varchar2 ) Is
1223: select tbls.user_table_id
1224: from pay_user_tables tbls
1225: where tbls.user_table_name = c_udt_name
1226: and ((business_group_id is null and legislation_code is null)
1227: or (legislation_code is not null
1228: and legislation_code = 'GB')

Line 1279: l_user_table_id pay_user_tables.user_table_id%TYPE;

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;
1283: l_proc_name varchar2(60) := g_proc_name || 'get_udt_data';

Line 1750: from pay_user_tables put

1746: select put.user_table_name
1747: ,puc.user_column_name
1748: ,pur.row_low_range_or_name
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

Line 1778: l_table_name pay_user_tables.user_table_name%TYPE;

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;
1779: l_proc_name varchar2(70) := g_proc_name || 'get_udt_value';
1780:
1781: Begin
1782: debug_enter (l_proc_name);

Line 5777: From pay_user_tables tbls

5773: ,c_udt_column_name in varchar2
5774: ,c_business_group_id in number
5775: ,c_legislation_code in varchar2) Is
5776: Select extv.value,extv.business_group_id
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

Line 17106: l_udt_name pay_user_tables.user_table_name%TYPE :=

17102: -- 115.49 : TLR
17103: l_tab_tlr_aln_eles t_allowance_eles;
17104:
17105: l_user_row_name pay_user_rows_f.row_low_range_or_name%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;