APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_ROLE_TYPES_B

Line 2110: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2106: , decode(r_delta, null, x_start_date, -- case B-2
2107: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2108: , decode(r_delta, null, x_completion_date, -- case B-2
2109: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2110: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2111: WHERE p.project_id = r_project_id
2112: AND p.project_role_id = r.project_role_id
2113: AND r.role_party_class = 'PERSON';
2114: /*Corrected the spelling of organization in the above csr for bug 2689578*/

Line 2127: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2123: p.start_date_active + r_delta) start_date_active
2124: , decode(r_delta, null, x_completion_date,
2125: p.end_date_active + r_delta) end_date_active
2126: , p.end_date_active source_end_date -- bug 12398459
2127: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2128: WHERE p.project_id = r_project_id
2129: AND p.project_role_id = r.project_role_id
2130: AND r.role_party_class = 'PERSON'
2131: AND r.project_role_type not in

Line 2326: pa_project_role_types_b r

2322:
2323: SELECT p.end_date_active + x_delta_1
2324: INTO role_end_date
2325: FROM pa_project_parties p,
2326: pa_project_role_types_b r
2327: WHERE p.project_id = x_orig_project_id
2328: AND p.project_role_id = r.project_role_id
2329: AND r.role_party_class = 'PERSON'
2330: AND p.project_party_id = c_role_based_loop_rec_2.project_party_id

Line 2473: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R

2469: , decode(r_delta, null, x_start_date, -- case B-2
2470: p.start_date_active + r_delta) start_date_active -- A,C,D,B-1
2471: , decode(r_delta, null, x_completion_date, -- case B-2
2472: p.end_date_active + r_delta) end_date_active -- A,C,D,B-1
2473: FROM pa_project_parties p,PA_PROJECT_ROLE_TYPES_B R
2474: WHERE p.project_id = r_project_id
2475: AND p.project_role_id = r.project_role_id
2476: AND r.role_party_class <> 'PERSON';
2477:

Line 2487: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R

2483: , decode(r_delta, null, x_start_date,
2484: p.start_date_active + r_delta) start_date_active
2485: , decode(r_delta, null, x_completion_date,
2486: p.end_date_active + r_delta) end_date_active
2487: FROM pa_project_parties p, PA_PROJECT_ROLE_TYPES_B R
2488: WHERE p.project_id = r_project_id
2489: AND p.project_role_id = r.project_role_id
2490: AND r.role_party_class <> 'PERSON'
2491: AND r.project_role_type not in