DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_BUDGET dependencies on PA_FP_WEBADI_XFACE_TMP

Line 462: UPDATE PA_FP_WEBADI_XFACE_TMP

458:
459: x_msg_count := 0;
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: UPDATE PA_FP_WEBADI_XFACE_TMP
463: SET val_error_code = p_error_code,
464: val_error_flag = 'Y'
465: WHERE resource_assignment_id = p_resource_assignment_id
466: AND

Line 469: FROM PA_FP_WEBADI_XFACE_TMP tmpchk

465: WHERE resource_assignment_id = p_resource_assignment_id
466: AND
467: NOT EXISTS
468: (SELECT 'Y'
469: FROM PA_FP_WEBADI_XFACE_TMP tmpchk
470: WHERE tmpchk.val_error_code IS NOT NULL
471: AND tmpchk.val_error_flag = 'Y'
472: AND resource_assignment_id = p_resource_assignment_id);
473: