APPS.PA_DELIVERABLE_UTILS dependencies on PA_LOOKUPS

Line 353: FROM pa_lookups

349: ORDER BY ppe.base_percent_comp_deriv_code;
350:
351: CURSOR c_lookup_meaning IS
352: SELECT meaning
353: FROM pa_lookups
354: WHERE lookup_type = 'PA_DLV_MORE'
355: AND lookup_code = 'MORE';
356: BEGIN
357: OPEN c_associated_tasks;

Line 677: l_system_status_code pa_lookups.lookup_code%TYPE ;

673: AND nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(ver.project_id,p_dlvr_version_id,ver.element_version_id) ,'N') = 'N'
674: )
675: );
676:
677: l_system_status_code pa_lookups.lookup_code%TYPE ;
678: l_status_change_allowed VARCHAR2(1) ;
679: BEGIN
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3349: FROM pa_lookups

3345: AND OBJ.relationship_subtype = 'TASK_TO_DELIVERABLE';
3346:
3347: CURSOR c_lookup_meaning IS
3348: SELECT meaning
3349: FROM pa_lookups
3350: WHERE lookup_type = 'PA_DLV_MORE'
3351: AND lookup_code = 'MORE';
3352:
3353: BEGIN

Line 4751: FROM pa_lookups

4747: IS
4748:
4749: CURSOR c_func_code IS
4750: SELECT 'X'
4751: FROM pa_lookups
4752: WHERE lookup_type = 'PA_DLVR_ACTION_FUNCTION'
4753: AND lookup_code = p_function_code;
4754:
4755: l_dummy VARCHAR2(1) := 'Y';