APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 104: INSERT INTO pay_user_column_instances_f

100: )
101: IS
102:
103: BEGIN
104: INSERT INTO pay_user_column_instances_f
105: (user_column_instance_id
106: ,effective_start_date
107: ,effective_end_date
108: ,user_row_id

Line 2655: INSERT INTO pay_user_column_instances_f

2651: P_LEGISLATION_SUBGROUP VARCHAR2 IN
2652: P_VALUE VARCHAR2 IN
2653: */
2654:
2655: INSERT INTO pay_user_column_instances_f
2656: (user_column_instance_id
2657: ,effective_start_date
2658: ,effective_end_date
2659: ,user_row_id

Line 2686: INSERT INTO pay_user_column_instances_f

2682: AND SYSDATE BETWEEN urws.effective_start_date
2683: AND urws.effective_end_date;
2684:
2685:
2686: INSERT INTO pay_user_column_instances_f
2687: (user_column_instance_id
2688: ,effective_start_date
2689: ,effective_end_date
2690: ,user_row_id

Line 2718: INSERT INTO pay_user_column_instances_f

2714: AND urws.effective_end_date;
2715:
2716:
2717:
2718: INSERT INTO pay_user_column_instances_f
2719: (user_column_instance_id
2720: ,effective_start_date
2721: ,effective_end_date
2722: ,user_row_id

Line 2750: INSERT INTO pay_user_column_instances_f

2746: AND urws.effective_end_date;
2747:
2748:
2749:
2750: INSERT INTO pay_user_column_instances_f
2751: (user_column_instance_id
2752: ,effective_start_date
2753: ,effective_end_date
2754: ,user_row_id

Line 3678: -- Delete pay_user_column_instances_f for this column_id

3674: LOOP
3675: FETCH csr_get_usr_col_id INTO l_usr_col_id;
3676: EXIT WHEN csr_get_usr_col_id%NOTFOUND;
3677:
3678: -- Delete pay_user_column_instances_f for this column_id
3679: l_proc_step := 30;
3680: IF g_debug THEN
3681: debug(l_proc_name, l_proc_step);
3682: END IF;

Line 3685: DELETE pay_user_column_instances_f

3681: debug(l_proc_name, l_proc_step);
3682: END IF;
3683:
3684:
3685: DELETE pay_user_column_instances_f
3686: WHERE user_column_id = l_usr_col_id;
3687:
3688: END LOOP;
3689: CLOSE csr_get_usr_col_id;