APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 20: g_extract_type pqp_extract_attributes.ext_dfn_type%TYPE;

16: --
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;

Line 80: -- Cursor to get extract details from PQP_EXTRACT_ATTRIBUTES table

76: --
77: -- Cursor Definitions
78: --
79:
80: -- Cursor to get extract details from PQP_EXTRACT_ATTRIBUTES table
81:
82: CURSOR csr_pqp_extract_attributes
83: IS
84: SELECT eat.ext_dfn_type, udt.user_table_name

Line 82: CURSOR csr_pqp_extract_attributes

78: --
79:
80: -- Cursor to get extract details from PQP_EXTRACT_ATTRIBUTES table
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

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