APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_PROJECT_PARTIES

Line 1295: pa_project_parties ppp,

1291: papf.email_address,
1292: papf.full_name person_name,
1293: ppp.resource_source_id
1294: from
1295: pa_project_parties ppp,
1296: fnd_user fu,per_all_people_f papf
1297: where ppp.project_id = l_project_id
1298: and ppp.project_role_id = To_number(l_role_id)
1299: and ppp.project_id = ppp.object_id

Line 2058: pa_project_parties ppp,

2054: CURSOR get_report_info IS
2055: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2056: pa_progress_reports_v pprv,
2057: pa_lookups pl,
2058: pa_project_parties ppp,
2059: per_all_people_f papf
2060: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2061: AND pl.lookup_code = pprv.progress_status_code
2062: and pprv.version_id = document_id

Line 2196: pa_project_parties ppp,

2192: CURSOR get_report_info IS
2193: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2194: pa_progress_reports_v pprv,
2195: pa_lookups pl,
2196: pa_project_parties ppp,
2197: per_all_people_f papf
2198: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2199: AND pl.lookup_code = pprv.progress_status_code
2200: and pprv.version_id = document_id

Line 2346: pa_project_parties ppp,

2342: CURSOR get_report_info IS
2343: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2344: pa_progress_report_vers pprv,
2345: pa_lookups pl,
2346: pa_project_parties ppp,
2347: per_all_people_f papf
2348: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2349: AND pl.lookup_code = pprv.progress_status_code
2350: and pprv.version_id = document_id

Line 2498: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(PPA.PROJECT_ID) person_name,

2494: --project_type,
2495: --to_char(project_value) as project_value,
2496: --psi_projfunc_currency_code as project_currency_code,
2497: --person_id,
2498: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(PPA.PROJECT_ID) person_name,
2499: ppa.segment1,
2500: --start_date,
2501: --completion_date,
2502: hou.name carrying_out_organization_name