DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 5431: FROM pa_expenditure_types_expend_v exptype

5427: )
5428:
5429: WHEN pai_project_exp_type IS NOT NULL
5430: AND NOT EXISTS (SELECT 1
5431: FROM pa_expenditure_types_expend_v exptype
5432: WHERE system_linkage_function = 'VI'
5433: AND exptype.expenditure_type = pai_project_exp_type
5434: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
5435: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))

Line 6103: FROM pa_expenditure_types_expend_v exptype

6099: p_user_id, SYSDATE, p_login_id -- 8
6100: )
6101: WHEN s_project_exp_type IS NOT NULL
6102: AND NOT EXISTS (SELECT 1
6103: FROM pa_expenditure_types_expend_v exptype
6104: WHERE system_linkage_function = 'VI'
6105: AND exptype.expenditure_type = s_project_exp_type
6106: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
6107: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))