APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_USER_TABLES

Line 21: g_extract_udt_name pay_user_tables.user_table_name%TYPE;

17: g_business_group_id NUMBER := NULL;
18: g_legislation_code VARCHAR2 (10) := 'GB';
19: g_effective_date DATE;
20: g_extract_type pqp_extract_attributes.ext_dfn_type%TYPE;
21: g_extract_udt_name pay_user_tables.user_table_name%TYPE;
22: g_effective_start_date DATE;
23: g_effective_end_date DATE;
24: g_header_system_element ben_ext_rslt_dtl.val_01%TYPE;
25: g_initial_ext_date DATE;

Line 85: FROM pqp_extract_attributes eat, pay_user_tables udt

81:
82: CURSOR csr_pqp_extract_attributes
83: IS
84: SELECT eat.ext_dfn_type, udt.user_table_name
85: FROM pqp_extract_attributes eat, pay_user_tables udt
86: WHERE eat.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
87: AND udt.user_table_id(+) = eat.ext_user_table_id;
88:
89: -- Cursor to get balance type id for a balance

Line 355: FROM pay_user_tables

351: -- Cursor to get user_table_id
352: CURSOR csr_get_udt_id (c_user_table_name VARCHAR2)
353: IS
354: SELECT user_table_id
355: FROM pay_user_tables
356: WHERE user_table_name = c_user_table_name
357: AND ( ( business_group_id IS NULL
358: AND legislation_code = g_legislation_code
359: )