APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_USER_TABLES

Line 1223: from pay_user_tables tbls

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

Line 1278: l_user_table_id pay_user_tables.user_table_id%TYPE;

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

Line 1749: from pay_user_tables put

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

Line 1777: l_table_name pay_user_tables.user_table_name%TYPE;

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

Line 5805: From pay_user_tables tbls

5801: ,c_udt_column_name in varchar2
5802: ,c_business_group_id in number
5803: ,c_legislation_code in varchar2) Is
5804: Select extv.value,extv.business_group_id
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

Line 17475: l_udt_name pay_user_tables.user_table_name%TYPE :=

17471: -- 115.49 : TLR
17472: l_tab_tlr_aln_eles t_allowance_eles;
17473:
17474: l_user_row_name pay_user_rows_f.row_low_range_or_name%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;