APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PAY_USER_TABLES

Line 21: g_extract_udt_name pay_user_tables.user_table_name%type;

17: g_extract_type fnd_lookups.lookup_code%type;
18: g_last_effective_date DATE;
19: g_next_effective_date DATE;
20: g_effective_run_date DATE;
21: g_extract_udt_name pay_user_tables.user_table_name%type;
22: g_criteria_location_code pay_user_column_instances_f.value%type;
23: g_lea_number VARCHAR2(3):=RPAD(' ',3,' ');
24: g_crossbg_enabled VARCHAR2(1) := 'N';
25: g_estb_number VARCHAR2(4):='0000';

Line 55: ,pay_user_tables udt

51: SELECT eat.ext_dfn_type
52: ,udt.user_table_name
53: ,udt.user_table_id
54: FROM pqp_extract_attributes eat
55: ,pay_user_tables udt
56: WHERE eat.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id)
57: AND udt.user_table_id(+) = eat.ext_user_table_id;
58: --
59: --