APPS.OTAFRUDT dependencies on PAY_USER_COLUMNS

Line 110: FROM pay_user_columns

106: v_user_column_name varchar2 (100);
107:
108: CURSOR user_column_id_csr IS
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

Line 136: PAY_USER_COLUMNS_PKG.INSERT_ROW

132: OPEN user_column_id_csr;
133: FETCH user_column_id_csr INTO v_user_column_id;
134: --
135: IF user_column_id_csr%NOTFOUND THEN
136: PAY_USER_COLUMNS_PKG.INSERT_ROW
137: (P_ROWID => v_column_row_id,
138: P_USER_COLUMN_ID => v_user_column_id,
139: P_USER_TABLE_ID => v_user_table_id,
140: P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_CC,

Line 250: FROM pay_user_columns_v

246: hr_utility.trace ('PROCEDURE create_row exiting');
247: --
248: SELECT user_column_id
249: INTO v_user_column_id
250: FROM pay_user_columns_v
251: WHERE user_column_name = P_USER_COLUMN_NAME_CR
252: AND user_table_id = v_user_table_id;
253: --
254: OPEN row_instance_csr (v_user_row_id, v_user_column_id);