eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 4169: -- FROM pa_expenditure_types_expend_v

4165: BEGIN
4166: -- Performance Tuning, Replaced he following query
4167: -- with the one below.
4168: -- SELECT expenditure_type INTO l_expenditure_type
4169: -- FROM pa_expenditure_types_expend_v
4170: -- WHERE expenditure_type IN ( select expenditure_type from pa_expenditure_types_expend_v et
4171: -- where system_linkage_function = 'VI'
4172: -- and et.project_id = P_Project_Id
4173: -- and et.expenditure_type = P_Expenditure_Type

Line 4170: -- WHERE expenditure_type IN ( select expenditure_type from pa_expenditure_types_expend_v et

4166: -- Performance Tuning, Replaced he following query
4167: -- with the one below.
4168: -- SELECT expenditure_type INTO l_expenditure_type
4169: -- FROM pa_expenditure_types_expend_v
4170: -- WHERE expenditure_type IN ( select expenditure_type from pa_expenditure_types_expend_v et
4171: -- where system_linkage_function = 'VI'
4172: -- and et.project_id = P_Project_Id
4173: -- and et.expenditure_type = P_Expenditure_Type
4174: -- and (sysdate between expnd_typ_start_date_active and

Line 4179: -- select expenditure_type from pa_expenditure_types_expend_v et

4175: -- nvl(expnd_typ_end_date_active, sysdate))
4176: -- and (sysdate between sys_link_start_date_active and
4177: -- nvl(sys_link_end_date_active,sysdate))
4178: -- union
4179: -- select expenditure_type from pa_expenditure_types_expend_v et
4180: -- where system_linkage_function = 'VI'
4181: -- and et.project_id is null
4182: -- and et.expenditure_type = P_Expenditure_Type
4183: -- and (sysdate between expnd_typ_start_date_active and

Line 4192: FROM pa_expenditure_types_expend_v et

4188:
4189:
4190: SELECT expenditure_type
4191: INTO l_expenditure_type
4192: FROM pa_expenditure_types_expend_v et
4193: WHERE system_linkage_function = 'VI'
4194: AND (sysdate between expnd_typ_start_date_active
4195: AND nvl(expnd_typ_end_date_active, sysdate))
4196: AND (sysdate between sys_link_start_date_active