APPS.OTAFRUDT dependencies on PAY_USER_TABLES

Line 24: PAY_USER_TABLES_PKG.INSERT_ROW

20:
21: v_table_rowid := NULL;
22: v_user_table_id := NULL;
23:
24: PAY_USER_TABLES_PKG.INSERT_ROW
25: (P_ROWID => v_table_rowid,
26: P_USER_TABLE_ID => v_user_table_id,
27: P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_ITD,
28: P_LEGISLATION_CODE => P_LEGISLATION_CODE_ITD,

Line 54: FROM pay_user_tables

50: IS
51: -- ensures table not already created for business group
52: CURSOR user_table_name_csr IS
53: SELECT user_table_name
54: FROM pay_user_tables
55: WHERE business_group_id = P_BUSINESS_GROUP_ID_CT
56: AND user_table_name = P_USER_TABLE_NAME_CT;
57:
58: v_legislation_code per_business_groups.legislation_code%TYPE;

Line 113: FROM pay_user_tables

109: SELECT user_column_id
110: FROM pay_user_columns
111: WHERE user_table_id =
112: (SELECT user_table_id
113: FROM pay_user_tables
114: WHERE business_group_id = P_BUSINESS_GROUP_ID_CC
115: AND user_table_name = P_USER_TABLE_NAME_CC)
116: AND user_column_name = P_USER_COLUMN_NAME_CC;
117:

Line 123: FROM pay_user_tables

119: hr_utility.trace ('PROCEDURE create column entered.');
120:
121: SELECT user_table_id
122: INTO v_user_table_id
123: FROM pay_user_tables
124: WHERE user_table_name = P_USER_TABLE_NAME_CC
125: AND business_group_id = P_BUSINESS_GROUP_ID_CC;
126: --
127: SELECT legislation_code

Line 181: FROM pay_user_tables

177: CURSOR user_row_id_csr IS
178: SELECT user_row_id
179: FROM pay_user_rows_f
180: WHERE user_table_id = (SELECT user_table_id
181: FROM pay_user_tables
182: WHERE user_table_name = P_USER_TABLE_NAME_CR
183: AND business_group_id = P_BUSINESS_GROUP_ID_CR)
184: AND P_ROW_LOW_RANGE_OR_NAME_CR = row_low_range_or_name;
185:

Line 197: FROM pay_user_tables

193: hr_utility.trace ('PROCEDURE create row entered.');
194: --
195: SELECT user_table_id, legislation_code
196: INTO v_user_table_id, v_legislation_code
197: FROM pay_user_tables
198: WHERE user_table_name = P_USER_TABLE_NAME_CR
199: AND business_group_id = P_BUSINESS_GROUP_ID_CR;
200: --
201: OPEN user_row_id_csr;