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.PA_EVENT_CORE dependencies on PA_PROJECTS

Line 17: FROM pa_projects_basic_v

13:
14: CURSOR SEL_PROJ_ID
15: IS
16: SELECT project_id
17: FROM pa_projects_basic_v
18: WHERE project_number=ltrim(rtrim(P_project_num))
19: AND project_type_class_code = 'CONTRACT'
20: AND template_flag <> 'Y'
21: AND pa_project_stus_utils.Is_Project_In_Purge_Status(project_status_code) <>'Y'

Line 64: FROM PA_PROJECTS

60:
61: CURSOR funding_level
62: IS
63: SELECT project_level_funding_flag
64: FROM PA_PROJECTS
65: WHERE project_id = P_project_id;
66:
67: BEGIN
68:

Line 1177: FROM pa_projects_all p,

1173:
1174: CURSOR GET_AGREEMENT_ID
1175: IS
1176: SELECT AG.AGREEMENT_ID
1177: FROM pa_projects_all p,
1178: pa_agreements_all ag,
1179: hz_cust_accounts cust,
1180: Pa_summary_project_fundings fun
1181: WHERE p.project_id = P_project_id