DBA Data[Home] [Help]

APPS.HR_FR_SEED_PKG dependencies on PAY_USER_COLUMNS

Line 108: FROM pay_user_columns

104: v_user_column_name varchar2 (100);
105:
106: CURSOR user_column_id_csr IS
107: SELECT user_column_id
108: FROM pay_user_columns
109: WHERE user_table_id =
110: (SELECT user_table_id
111: FROM pay_user_tables
112: WHERE business_group_id = P_BUSINESS_GROUP_ID_CC

Line 135: PAY_USER_COLUMNS_PKG.INSERT_ROW

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

Line 255: FROM pay_user_columns_v

251: hr_utility.trace ('PROCEDURE create_row exiting');
252: --
253: SELECT user_column_id
254: INTO v_user_column_id
255: FROM pay_user_columns_v
256: WHERE user_column_name = P_USER_COLUMN_NAME_CR
257: AND user_table_id = v_user_table_id;
258: --
259: OPEN row_instance_csr (v_user_row_id, v_user_column_id);

Line 3059: , pay_user_columns c

3055: ,p_seeded_data => 'Y'
3056: ,p_count_clause2 => ''
3057: ,p_where_clause => 'from hr_soft_coding_keyflex scl
3058: , pay_user_column_instances_f i
3059: , pay_user_columns c
3060: , pay_user_rows_f r
3061: , pay_user_tables t
3062: , per_all_people_f p
3063: , per_all_assignments_f a