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_ADVERTISEMENTS_PVT dependencies on PA_PROJECT_PARTIES

Line 1017: --FROM pa_project_parties pp,

1013: --cursor to get tpeople on the project role
1014: -- Commented for Performance Fix 4898314 SQL ID 14906391
1015: --CURSOR get_person_on_project_role IS
1016: --SELECT rv.resource_source_id, rv.resource_name
1017: --FROM pa_project_parties pp,
1018: -- pa_c_resource_v rv
1019: --WHERE pp.project_id = p_project_id
1020: -- AND pp.project_role_id = p_project_role_id
1021: -- AND pp.resource_source_id = rv.resource_source_id;

Line 1026: FROM pa_project_parties pp,

1022:
1023: -- Start of Performance Fix 4898314 SQL ID 14906391
1024: CURSOR get_person_on_project_role IS
1025: SELECT per.person_id resource_source_id, per.full_name resource_name
1026: FROM pa_project_parties pp,
1027: per_people_f per
1028: WHERE pp.project_id = p_project_id
1029: AND pp.project_role_id = p_project_role_id
1030: AND pp.resource_source_id = per.person_id

Line 1240: l_project_manager_id pa_project_parties.resource_source_id%TYPE;

1236: --l_project_customer RA_CUSTOMERS.customer_name%TYPE;
1237: l_project_customer hz_parties.party_name%TYPE;
1238: -- 4363092 done
1239: l_project_manager per_all_people_f.full_name%TYPE;
1240: l_project_manager_id pa_project_parties.resource_source_id%TYPE;
1241: l_effort pa_project_assignments.assignment_effort%TYPE;
1242: l_duration NUMBER;
1243: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
1244: l_index NUMBER;

Line 1321: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),

1317: CURSOR get_project_info IS
1318: SELECT proj.name,
1319: proj.segment1,
1320: hou.name,
1321: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),
1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,
1323: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(proj.project_id)
1324: FROM pa_projects_all proj,
1325: HR_ALL_ORGANIZATION_UNITS HOU

Line 1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,

1318: SELECT proj.name,
1319: proj.segment1,
1320: hou.name,
1321: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),
1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,
1323: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(proj.project_id)
1324: FROM pa_projects_all proj,
1325: HR_ALL_ORGANIZATION_UNITS HOU
1326: WHERE proj.project_id = p_project_id