DBA Data[Home] [Help]

APPS.PA_AP_INTEGRATION dependencies on PA_RESOURCE_ASSIGNMENTS

Line 396: from pa_resource_assignments assign, pa_resource_list_members member, pa_budget_lines budget

392:
393: /* -- Original Logic
394:
395: select 'Y' into l_budget_exists
396: from pa_resource_assignments assign, pa_resource_list_members member, pa_budget_lines budget
397: where assign.RESOURCE_LIST_MEMBER_ID=member.RESOURCE_LIST_MEMBER_ID
398: and member.vendor_id = p_vendor_id
399: and budget.resource_assignment_id = assign.resource_assignment_id
400: and rownum < 2 ;

Line 409: from pa_resource_assignments assign

405: -- FP.M Data Model Logic
406:
407: select 'Y'
408: into l_budget_exists
409: from pa_resource_assignments assign
410: , pa_resource_list_members member
411: , pa_budget_lines budget
412: where assign.RESOURCE_LIST_MEMBER_ID=member.RESOURCE_LIST_MEMBER_ID
413: and member.vendor_id = p_vendor_id