DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 6286: FROM pa_expenditure_types_expend_v exptype

6282: )
6283:
6284: WHEN pai_project_exp_type IS NOT NULL
6285: AND NOT EXISTS (SELECT 1
6286: FROM pa_expenditure_types_expend_v exptype
6287: WHERE system_linkage_function = 'VI'
6288: AND exptype.expenditure_type = pai_project_exp_type
6289: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
6290: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))

Line 6960: FROM pa_expenditure_types_expend_v exptype

6956: p_user_id, SYSDATE, p_login_id -- 8
6957: )
6958: WHEN s_project_exp_type IS NOT NULL
6959: AND NOT EXISTS (SELECT 1
6960: FROM pa_expenditure_types_expend_v exptype
6961: WHERE system_linkage_function = 'VI'
6962: AND exptype.expenditure_type = s_project_exp_type
6963: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
6964: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))