DBA Data[Home] [Help]

APPS.PA_FC_RES_MAP dependencies on PA_RESOURCE_MAPS

Line 18: DELETE pa_resource_maps;

14: END IF;
15: x_return_status := fnd_api.g_ret_sts_success;
16:
17: IF (p_resource_list_assignment_id is null) THEN
18: DELETE pa_resource_maps;
19: ELSE
20: DELETE pa_resource_maps prm
21: WHERE prm.resource_list_assignment_id = p_resource_list_assignment_id;
22: END IF;

Line 20: DELETE pa_resource_maps prm

16:
17: IF (p_resource_list_assignment_id is null) THEN
18: DELETE pa_resource_maps;
19: ELSE
20: DELETE pa_resource_maps prm
21: WHERE prm.resource_list_assignment_id = p_resource_list_assignment_id;
22: END IF;
23: IF P_DEBUG_MODE = 'Y' THEN
24: pa_fck_util.debug_msg('delete_res_maps_on_asgn_id: ' || 'PB:Exiting - Delete Resource Maps');