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_PUB dependencies on PA_PROJECTS_ALL

Line 209: from pa_projects_all

205:
206: Cursor l_temp_eff_flag_csr(p_proj_id NUMBER)
207: Is
208: select 'N'
209: from pa_projects_all
210: where project_id = p_proj_id
211: and template_flag = 'Y'
212: and ((nvl(trunc(template_start_date_active), trunc(sysdate)) > trunc(sysdate)) or
213: (nvl(trunc(template_end_date_active), trunc(sysdate)) < trunc(sysdate)));

Line 434: FROM pa_projects_all

430:
431: --Bug 3279981
432: CURSOR cur_get_orig_tt_cust_flag( c_project_id IN NUMBER ) IS
433: SELECT enable_top_task_customer_flag
434: FROM pa_projects_all
435: WHERE project_id = c_project_id ;
436:
437: l_orig_def_tt_flag VARCHAR2(1);
438: l_cust_bill_split NUMBER;

Line 471: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

467:
468: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
469: CURSOR c_prj(c_project_id IN NUMBER ) IS
470: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
471: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
472: where ppa.project_id = c_project_id
473: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
474: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
475: and pps.STATUS_TYPE = 'PROJECT'

Line 486: l_proj_status pa_projects_all.project_status_code%TYPE;

482: from pa_project_players
483: where project_id = c_project_id
484: and project_role_type='PROJECT MANAGER';
485:
486: l_proj_status pa_projects_all.project_status_code%TYPE;
487: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
488: l_prj_mgr_count NUMBER;
489: /* End of code for bug #2111806. */
490:

Line 563: pa_projects_all

559: IS
560: SELECT
561: nvl(DATE_EFF_FUNDS_CONSUMPTION,'N')
562: FROM
563: pa_projects_all
564: WHERE project_id = c_project_id ;
565:
566: /* 7508661 : EnC : Start */
567:

Line 576: pa_projects_all

572: IS
573: SELECT
574: nvl(AR_REC_NOTIFY_FLAG,'N')
575: FROM
576: pa_projects_all
577: WHERE project_id = c_project_id ;
578:
579: l_auto_release_pwp_inv VARCHAR2(1);
580: l_orig_auto_release_pwp_inv VARCHAR2(1);

Line 587: pa_projects_all

583: IS
584: SELECT
585: nvl(AUTO_RELEASE_PWP_INV,'Y')
586: FROM
587: pa_projects_all
588: WHERE project_id = c_project_id ;
589:
590: /* 7508661 : EnC : End */
591:

Line 596: pa_projects_all p,

592: CURSOR cur_enable_funds_flag(p_project_id IN VARCHAR2)
593: IS
594: SELECT 'Y'
595: FROM
596: pa_projects_all p,
597: pa_project_types_all pt
598: WHERE
599: p.project_id = p_project_id AND
600: pt.project_type_class_code = 'CONTRACT' AND

Line 662: from pa_projects_all

658:
659: /*Added for bug 7830143*/
660: CURSOR c_get_org_id(c_project_id NUMBER) IS
661: select org_id
662: from pa_projects_all
663: where project_id = c_project_id;
664:
665: l_org_id NUMBER ;
666: /*Added for bug 7830143*/

Line 1165: from pa_projects_all

1161:
1162: l_created_from_proj_id := l_project_in_rec.created_from_project_id;
1163: else
1164: select created_from_project_id into l_created_from_proj_id
1165: from pa_projects_all
1166: where project_id = l_project_in_rec.created_from_project_id;
1167: end if;
1168: --code addition for bug 2254661 ends
1169:

Line 5648: FROM pa_projects_all

5644: --Bug 3279981. Fetch project information
5645: CURSOR cur_get_proj_billing_info IS
5646: SELECT enable_top_task_customer_flag, enable_top_task_inv_mth_flag,
5647: revenue_accrual_method, invoice_method, project_type
5648: FROM pa_projects_all
5649: WHERE project_id = p_pa_project_id;
5650:
5651: CURSOR cur_check_proj_cust_exist (c_customer_id IN NUMBER ) IS
5652: SELECT 'Y'

Line 9629: FROM pa_projects_all

9625: --needed to check whether given project number is unique
9626: CURSOR l_project_number_unique_csr( p_project_number VARCHAR2)
9627: IS
9628: SELECT 'x'
9629: FROM pa_projects_all
9630: WHERE segment1 = p_project_number;
9631:
9632: --needed to check whether given project name is unique
9633: CURSOR l_project_name_unique_csr( p_project_name VARCHAR2)

Line 9636: FROM pa_projects_all

9632: --needed to check whether given project name is unique
9633: CURSOR l_project_name_unique_csr( p_project_name VARCHAR2)
9634: IS
9635: SELECT 'x'
9636: FROM pa_projects_all
9637: WHERE name = p_project_name;
9638:
9639: --needed to check whether given long name is unique
9640: CURSOR l_long_name_unique_csr( p_long_name VARCHAR2)

Line 9643: FROM pa_projects_all

9639: --needed to check whether given long name is unique
9640: CURSOR l_long_name_unique_csr( p_long_name VARCHAR2)
9641: IS
9642: SELECT 'x'
9643: FROM pa_projects_all
9644: WHERE long_name = p_long_name;
9645:
9646: /* Modidified the cursor l_key_member_csr to add start_date_active as logical
9647: primary key */

Line 9765: pa_projects_all ppa,

9761: NULL USER_NAME,
9762: -999 USER_ID,
9763: ppp.resource_source_id RESOURCE_PARTY_ID
9764: FROM pa_project_parties ppp,
9765: pa_projects_all ppa,
9766: pa_project_role_types_vl pprt,
9767: hz_parties hzo,
9768: hz_contact_points hzcp
9769: WHERE ppp.resource_type_id = 112

Line 9827: pa_projects_all ppa,

9823: NULL USER_NAME,
9824: -999 USER_ID,
9825: ppp.resource_source_id RESOURCE_PARTY_ID
9826: FROM pa_project_parties ppp,
9827: pa_projects_all ppa,
9828: pa_project_role_types_vl pprt,
9829: hz_parties hzo
9830: WHERE ppp.resource_type_id = 112
9831: AND ppp.project_id = ppa.project_id

Line 9844: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

9840:
9841: -- 3693229 end
9842:
9843: --Cursor to get the current published version when structure type and project id is known
9844: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
9845: IS
9846: SELECT c.element_version_id
9847: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
9848: ,pa_proj_elem_ver_structure d

Line 9859: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

9855: AND d.status_code = 'STRUCTURE_PUBLISHED'
9856: AND d.latest_eff_published_flag = 'Y';
9857:
9858: --Cursor to get the working version when structure type and project id is known
9859: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
9860: IS
9861: SELECT c.element_version_id
9862: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
9863: ,pa_proj_elem_ver_structure d

Line 9875: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa

9871:
9872: -- Cursor to get the Project's System Status Code Bug 3611598
9873: CURSOR c_project_sys_status_code IS
9874: SELECT project_system_status_code
9875: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa
9876: WHERE pa.project_id = p_project_in.pa_project_id
9877: AND sta.project_status_code = pa.project_status_code;
9878:
9879: TYPE deferred_tasks_rec IS RECORD

Line 10246: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

10242:
10243: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
10244: CURSOR c_prj(c_project_id IN NUMBER ) IS
10245: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
10246: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
10247: where ppa.project_id = c_project_id
10248: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
10249: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
10250: and pps.STATUS_TYPE = 'PROJECT'

Line 10261: l_proj_status pa_projects_all.project_status_code%TYPE;

10257: from pa_project_players
10258: where project_id = c_project_id
10259: and project_role_type='PROJECT MANAGER';
10260:
10261: l_proj_status pa_projects_all.project_status_code%TYPE;
10262: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
10263: l_prj_mgr_count NUMBER;
10264: /* End of code for bug #2111806. */
10265:

Line 10337: from pa_projects_all ppa

10333: -- Bug # 4329284.
10334:
10335: cursor cur_proj_name (c_project_id NUMBER) is
10336: select ppa.name
10337: from pa_projects_all ppa
10338: where ppa.project_id = c_project_id;
10339:
10340: cursor cur_prog_name (c_project_id NUMBER) is
10341: select ppa.name

Line 10342: from pa_projects_all ppa, pa_object_relationships por

10338: where ppa.project_id = c_project_id;
10339:
10340: cursor cur_prog_name (c_project_id NUMBER) is
10341: select ppa.name
10342: from pa_projects_all ppa, pa_object_relationships por
10343: where ppa.project_id = por.object_id_to2
10344: and por.object_id_to2 = c_project_id
10345: and por.relationship_type in ('LW','LF')
10346: union all

Line 10348: from pa_projects_all ppa, pa_object_relationships por

10344: and por.object_id_to2 = c_project_id
10345: and por.relationship_type in ('LW','LF')
10346: union all
10347: select ppa.name
10348: from pa_projects_all ppa, pa_object_relationships por
10349: where ppa.project_id = por.object_id_from2
10350: and por.object_id_from2 = c_project_id
10351: and por.relationship_type in ('LW','LF');
10352:

Line 10490: pa_projects_all proj

10486: IS
10487: select 'x'
10488: from pa_project_role_types_v roles,
10489: pa_role_controls controls,
10490: pa_projects_all proj
10491: where proj.project_id=p_project_id
10492: and proj.ROLE_LIST_ID is null
10493: and roles.project_role_id=controls.project_role_id
10494: and roles.PROJECT_ROLE_TYPE=p_role_type

Line 10501: pa_projects_all proj,

10497: union all
10498: select 'x'
10499: from pa_project_role_types_v roles,
10500: pa_role_controls controls,
10501: pa_projects_all proj,
10502: pa_role_list_members prlm
10503: where proj.project_id=p_project_id
10504: and proj.ROLE_LIST_ID =prlm.role_list_id
10505: and prlm.project_role_id = roles.project_role_id

Line 10522: pa_projects_all p,

10518: CURSOR cur_enable_funds_flag(p_project_id IN VARCHAR2)
10519: IS
10520: SELECT 'Y'
10521: FROM
10522: pa_projects_all p,
10523: pa_project_types_all pt
10524: WHERE
10525: p.project_id = p_project_id AND
10526: pt.project_type_class_code = 'CONTRACT' AND

Line 16202: UPDATE pa_projects_all

16198: --Update the distribution rule with the correct invoice method, if no distribution rule has been passed
16199: --Call the api to default the invoice method to the tasks
16200: IF 'Y' = l_enable_top_task_inv_mth_flag AND 'N' = p_project_in.enable_top_task_inv_mth_flag THEN
16201: IF nvl(p_project_in.distribution_rule,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
16202: UPDATE pa_projects_all
16203: SET distribution_rule =
16204: substr(distribution_rule,1,instr(distribution_rule,'/')-1)||'/'||l_proj_invoice_method
16205: WHERE project_id = l_project_id;
16206: END IF;

Line 16239: UPDATE pa_projects_all

16235:
16236: --IF the invoice method at top task flag is checked,
16237: --invoice method of the distribution rule must internally be populated as WORK
16238: IF 'Y' = l_proj_top_task_inv_mth_flag THEN
16239: UPDATE pa_projects_all
16240: SET distribution_rule =
16241: substr(distribution_rule,1,instr(distribution_rule,'/')-1)||'/'||'WORK'
16242: WHERE project_id = l_project_id;
16243: END IF;

Line 22339: FROM pa_projects_all

22335: --Bug 3279981. Fetch project information
22336: CURSOR cur_get_proj_billing_info(c_project_id IN NUMBER) IS
22337: SELECT enable_top_task_customer_flag, enable_top_task_inv_mth_flag,
22338: revenue_accrual_method, invoice_method, project_type
22339: FROM pa_projects_all
22340: WHERE project_id = c_project_id;
22341:
22342: CURSOR cur_check_proj_cust_exist (c_project_id IN NUMBER , c_customer_id IN NUMBER ) IS
22343: SELECT 'Y'

Line 29466: l_project_number Pa_Projects_All.Segment1%TYPE;

29462: IS
29463:
29464: l_project_id NUMBER;
29465: l_task_id NUMBER;
29466: l_project_number Pa_Projects_All.Segment1%TYPE;
29467: l_task_number Pa_Proj_Elements.Name%TYPE;
29468: l_task_source_reference VARCHAR2(240);
29469: l_deliverable_element_id NUMBER;
29470: l_deliverable_version_id NUMBER;

Line 29691: FROM Pa_Projects_All

29687: l_task_number := null;
29688: END IF;
29689:
29690: SELECT segment1 INTO l_project_number
29691: FROM Pa_Projects_All
29692: WHERE project_id = l_project_id;
29693:
29694: IF p_debug_mode = 'Y' THEN
29695: pa_debug.g_err_stage := 'Creating deliverable ['|| p_deliverable_short_name||']['||p_pm_deliverable_reference||']['

Line 30143: l_project_number Pa_Projects_All.Segment1%TYPE;

30139: l_action_out_tbl action_out_tbl_type ;
30140:
30141: l_project_id NUMBER;
30142: l_task_id NUMBER;
30143: l_project_number Pa_Projects_All.Segment1%TYPE;
30144: l_task_number Pa_Proj_Elements.Name%TYPE;
30145: l_dlvr_type_id Pa_Proj_Elements.type_id%TYPE;
30146:
30147: l_dlvr_prg_enabled VARCHAR2(1) := NULL;

Line 34519: from pa_projects_all

34515:
34516: CURSOR get_template_flag(c_project_id NUMBER)
34517: IS
34518: select template_flag
34519: from pa_projects_all
34520: where project_id = c_project_id;
34521:
34522: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
34523: IS

Line 34770: from pa_projects_all

34766:
34767: CURSOR get_template_flag(c_project_id NUMBER)
34768: IS
34769: select template_flag
34770: from pa_projects_all
34771: where project_id = c_project_id;
34772:
34773: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
34774: IS

Line 35031: from pa_projects_all

35027:
35028: CURSOR get_template_flag(c_project_id NUMBER)
35029: IS
35030: select template_flag
35031: from pa_projects_all
35032: where project_id = c_project_id;
35033:
35034: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35035: IS

Line 36006: pa_projects_all ppa

36002: ,ppes.element_version_id structure_version_id
36003: ,ppa.segment1 project_number
36004: ,ppes.name structure_name
36005: from pa_proj_elem_ver_structure ppes,
36006: pa_projects_all ppa
36007: where ppa.project_id = ppes.project_id
36008: and ppes.process_update_wbs_flag = 'Y'
36009: and NVL(ppes.process_code,'WUE') = 'WUE'
36010: and ppa.segment1 between nvl(p_project_num_from,ppa.segment1)

Line 36183: from pa_projects_all ppa

36179: l_allow_multi_program_rollup VARCHAR2(1) := NULL;
36180:
36181: cursor l_cur_sys_program_flag(c_project_id NUMBER) is
36182: select ppa.sys_program_flag
36183: from pa_projects_all ppa
36184: where ppa.project_id = c_project_id;
36185:
36186: cursor l_cur_allow_multi_prog_rollup(c_project_id NUMBER) is
36187: select ppa.allow_multi_program_rollup

Line 36188: from pa_projects_all ppa

36184: where ppa.project_id = c_project_id;
36185:
36186: cursor l_cur_allow_multi_prog_rollup(c_project_id NUMBER) is
36187: select ppa.allow_multi_program_rollup
36188: from pa_projects_all ppa
36189: where ppa.project_id = c_project_id;
36190:
36191: l_msg_index_out NUMBER := NULL;
36192: l_return_status VARCHAR2(1) := NULL;

Line 36413: from pa_projects_all ppa, pa_proj_element_versions ppev

36409: l_msg_data VARCHAR2(2000) := NULL;
36410:
36411: cursor l_cur_prog_name (c_task_version_id NUMBER) is
36412: select ppa.name
36413: from pa_projects_all ppa, pa_proj_element_versions ppev
36414: where ppa.project_id = ppev.project_id
36415: and ppev.element_version_id = c_task_version_id;
36416:
36417: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 36419: from pa_projects_all ppa

36415: and ppev.element_version_id = c_task_version_id;
36416:
36417: cursor l_cur_prog_name2 (c_project_id NUMBER) is
36418: select ppa.name
36419: from pa_projects_all ppa
36420: where ppa.project_id = c_project_id;
36421:
36422: cursor l_cur_proj_name (c_project_id NUMBER) is
36423: select ppa.name

Line 36424: from pa_projects_all ppa

36420: where ppa.project_id = c_project_id;
36421:
36422: cursor l_cur_proj_name (c_project_id NUMBER) is
36423: select ppa.name
36424: from pa_projects_all ppa
36425: where ppa.project_id = c_project_id;
36426:
36427: cursor l_cur_task_name (c_task_ver_id NUMBER) is
36428: select ppe.name

Line 36436: from pa_projects_all ppa

36432: and ppev.element_version_id = c_task_ver_id;
36433:
36434: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
36435: select ppa.project_id
36436: from pa_projects_all ppa
36437: where pm_project_reference = c_sub_project_reference
36438: and ppa.project_id = c_sub_project_id;
36439:
36440: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is

Line 36442: from pa_projects_all ppa

36438: and ppa.project_id = c_sub_project_id;
36439:
36440: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is
36441: select ppa.project_id
36442: from pa_projects_all ppa
36443: where pm_project_reference = c_sub_project_reference;
36444:
36445: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
36446: select ppa.project_id

Line 36447: from pa_projects_all ppa

36443: where pm_project_reference = c_sub_project_reference;
36444:
36445: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
36446: select ppa.project_id
36447: from pa_projects_all ppa
36448: where ppa.project_id = c_sub_project_id;
36449:
36450: l_parent_sub_flag VARCHAR2(1) := NULL;
36451:

Line 36991: from pa_projects_all ppa, pa_proj_element_versions ppev

36987: and por.object_relationship_id = c_object_relationship_id;
36988:
36989: cursor l_cur_prog_name (c_task_version_id NUMBER) is
36990: select ppa.name
36991: from pa_projects_all ppa, pa_proj_element_versions ppev
36992: where ppa.project_id = ppev.project_id
36993: and ppev.element_version_id = c_task_version_id;
36994:
36995: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 36997: from pa_projects_all ppa

36993: and ppev.element_version_id = c_task_version_id;
36994:
36995: cursor l_cur_prog_name2 (c_project_id NUMBER) is
36996: select ppa.name
36997: from pa_projects_all ppa
36998: where ppa.project_id = c_project_id;
36999:
37000: cursor l_cur_proj_name (c_project_id NUMBER) is
37001: select ppa.name

Line 37002: from pa_projects_all ppa

36998: where ppa.project_id = c_project_id;
36999:
37000: cursor l_cur_proj_name (c_project_id NUMBER) is
37001: select ppa.name
37002: from pa_projects_all ppa
37003: where ppa.project_id = c_project_id;
37004:
37005: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37006: select ppe.name

Line 37019: from pa_projects_all ppa

37015: where ppev.element_version_id = c_task_version_id;
37016:
37017: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37018: select ppa.project_id
37019: from pa_projects_all ppa
37020: where pm_project_reference = c_sub_project_reference
37021: and ppa.project_id = c_sub_project_id;
37022:
37023: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is

Line 37025: from pa_projects_all ppa

37021: and ppa.project_id = c_sub_project_id;
37022:
37023: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is
37024: select ppa.project_id
37025: from pa_projects_all ppa
37026: where pm_project_reference = c_sub_project_reference;
37027:
37028: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37029: select ppa.project_id

Line 37030: from pa_projects_all ppa

37026: where pm_project_reference = c_sub_project_reference;
37027:
37028: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37029: select ppa.project_id
37030: from pa_projects_all ppa
37031: where ppa.project_id = c_sub_project_id;
37032:
37033: l_parent_sub_flag VARCHAR2(1) := NULL;
37034:

Line 37579: from pa_projects_all ppa, pa_proj_element_versions ppev

37575: and por.object_relationship_id = c_object_relationship_id;
37576:
37577: cursor l_cur_prog_name (c_task_version_id NUMBER) is
37578: select ppa.name
37579: from pa_projects_all ppa, pa_proj_element_versions ppev
37580: where ppa.project_id = ppev.project_id
37581: and ppev.element_version_id = c_task_version_id;
37582:
37583: cursor l_cur_proj_name (c_project_id NUMBER) is

Line 37585: from pa_projects_all ppa

37581: and ppev.element_version_id = c_task_version_id;
37582:
37583: cursor l_cur_proj_name (c_project_id NUMBER) is
37584: select ppa.name
37585: from pa_projects_all ppa
37586: where ppa.project_id = c_project_id;
37587:
37588: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37589: select ppe.name

Line 37602: from pa_projects_all ppa

37598: where ppev.element_version_id = c_task_version_id;
37599:
37600: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37601: select ppa.project_id
37602: from pa_projects_all ppa
37603: where pm_project_reference = c_sub_project_reference
37604: and ppa.project_id = c_sub_project_id;
37605:
37606: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is

Line 37608: from pa_projects_all ppa

37604: and ppa.project_id = c_sub_project_id;
37605:
37606: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is
37607: select ppa.project_id
37608: from pa_projects_all ppa
37609: where pm_project_reference = c_sub_project_reference;
37610:
37611: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37612: select ppa.project_id

Line 37613: from pa_projects_all ppa

37609: where pm_project_reference = c_sub_project_reference;
37610:
37611: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37612: select ppa.project_id
37613: from pa_projects_all ppa
37614: where ppa.project_id = c_sub_project_id;
37615:
37616: l_program_name VARCHAR2(30) := NULL;
37617: l_project_name VARCHAR2(30) := NULL;