DBA Data[Home] [Help]

APPS.PQP_COPY_UDT dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 288: FROM pay_user_column_instances_f

284: PROCEDURE copy_column_instances IS
285:
286: CURSOR c_user_ci(p_user_column_id IN NUMBER) IS
287: SELECT *
288: FROM pay_user_column_instances_f
289: WHERE user_column_id = p_user_column_id
290: ORDER BY user_column_instance_id, effective_start_date;
291:
292: r_user_ci c_user_ci%ROWTYPE;

Line 344: -- Insert into PAY_USER_COLUMN_INSTANCES_F

340:
341: -- For the current USER_ROW_ID, find the corresponding new USER_ROW_ID
342: l_new_pur_id := get_new_pur_id(p_curr_pur_id => r_user_ci.user_row_id);
343:
344: -- Insert into PAY_USER_COLUMN_INSTANCES_F
345: pay_user_column_instances_pkg.insert_row
346: (p_rowid => l_row_id -- IN OUT
347: ,p_user_column_instance_id => l_new_puci_id -- IN OUT
348: ,p_effective_start_date => r_user_ci.effective_start_date

Line 425: -- Copy PAY_USER_COLUMN_INSTANCES_F data

421: copy_rows(p_curr_put_id => p_curr_udt_id
422: ,p_new_put_id => l_new_put_id
423: );
424:
425: -- Copy PAY_USER_COLUMN_INSTANCES_F data
426: copy_column_instances;
427:
428: hr_utility.set_location('Leaving:'|| l_proc, 20);
429: