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_PROJECT_CORE1 dependencies on PA_PROJECT_ROLE_TYPES_B

Line 2074: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2070: , decode(r_delta, null, x_start_date, -- case B-2
2071: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2072: , decode(r_delta, null, x_completion_date, -- case B-2
2073: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2074: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2075: WHERE p.project_id = r_project_id
2076: AND p.project_role_id = r.project_role_id
2077: AND r.role_party_class = 'PERSON';
2078: /*Corrected the spelling of organization in the above csr for bug 2689578*/

Line 2090: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2086: , decode(r_delta, null, x_start_date,
2087: p.start_date_active + r_delta) start_date_active
2088: , decode(r_delta, null, x_completion_date,
2089: p.end_date_active + r_delta) end_date_active
2090: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2091: WHERE p.project_id = r_project_id
2092: AND p.project_role_id = r.project_role_id
2093: AND r.role_party_class = 'PERSON'
2094: AND r.project_role_type not in

Line 2283: pa_project_role_types_b r

2279:
2280: SELECT p.end_date_active + x_delta_1
2281: INTO role_end_date
2282: FROM pa_project_parties p,
2283: pa_project_role_types_b r
2284: WHERE p.project_id = x_orig_project_id
2285: AND p.project_role_id = r.project_role_id
2286: AND r.role_party_class = 'PERSON'
2287: AND p.project_party_id = c_role_based_loop_rec_2.project_party_id

Line 2430: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2426: , decode(r_delta, null, x_start_date, -- case B-2
2427: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2428: , decode(r_delta, null, x_completion_date, -- case B-2
2429: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2430: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2431: WHERE p.project_id = r_project_id
2432: AND p.project_role_id = r.project_role_id
2433: AND r.role_party_class <> 'PERSON';
2434:

Line 2444: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R

2440: , decode(r_delta, null, x_start_date,
2441: p.start_date_active + r_delta) start_date_active
2442: , decode(r_delta, null, x_completion_date,
2443: p.end_date_active + r_delta) end_date_active
2444: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R
2445: WHERE p.project_id = r_project_id
2446: AND p.project_role_id = r.project_role_id
2447: AND r.role_party_class <> 'PERSON'
2448: AND r.project_role_type not in