DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on PAY_USER_TABLES

Line 19: table_name pay_user_tables.user_table_name%TYPE

15:
16:
17:
18: TYPE t_tbls IS RECORD(
19: table_name pay_user_tables.user_table_name%TYPE
20: ,column_name pay_user_columns.user_column_name%TYPE
21: );
22:
23: TYPE t_cached_tbls IS TABLE OF t_tbls

Line 30: TYPE t_cached_udt IS TABLE OF pay_user_tables.user_table_name%TYPE

26: g_cached_tbls t_cached_tbls;
27:
28:
29:
30: TYPE t_cached_udt IS TABLE OF pay_user_tables.user_table_name%TYPE
31: INDEX BY BINARY_INTEGER;
32:
33: g_cached_udts t_cached_udt;
34:

Line 36: table_name pay_user_tables.user_table_name%TYPE

32:
33: g_cached_udts t_cached_udt;
34:
35: TYPE t_udt_rec IS RECORD(
36: table_name pay_user_tables.user_table_name%TYPE
37: , -- Comment
38: column_name pay_user_columns.user_column_name%TYPE
39: ,row_name pay_user_rows_f.row_low_range_or_name%TYPE
40: ,row_high_range pay_user_rows_f.row_high_range%TYPE

Line 62: table_name pay_user_tables.user_table_name%TYPE

58: -- global cache pointer record structure.This is used
59: -- as template for hash-buckets.
60: TYPE t_cached_udt_bucket_rec IS RECORD
61: (
62: table_name pay_user_tables.user_table_name%TYPE
63: ,business_group_id NUMBER(15)
64: ,start_index NUMBER (15)
65: ,rec_count NUMBER(15)
66: );

Line 240: FROM pay_user_tables

236: -- Cursor to get User Defined Table ID for a given UDT Name.
237: CURSOR csr_table_id(p_table_id IN NUMBER)
238: IS
239: SELECT user_table_name
240: FROM pay_user_tables
241: WHERE user_table_id = p_table_id;
242:
243: -- Cursor to get Legislation Code from a Business Group Id.
244: CURSOR csr_leg_code(p_business_group_id IN NUMBER)