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_PVT dependencies on PA_PROJECTS

Line 84: pa_projects_all proj

80: IS
81: SELECT 'x'
82: FROM pa_project_role_types_v roles,
83: pa_role_controls controls,
84: pa_projects_all proj
85: WHERE proj.project_id = p_project_id
86: AND proj.ROLE_LIST_ID is null
87: AND roles.project_role_id = controls.project_role_id
88: AND roles.PROJECT_ROLE_TYPE = p_role_type

Line 95: pa_projects_all proj,

91: UNION ALL
92: SELECT 'x'
93: FROM pa_project_role_types_v roles,
94: pa_role_controls controls,
95: pa_projects_all proj,
96: pa_role_list_members prlm
97: WHERE proj.project_id = p_project_id
98: AND proj.ROLE_LIST_ID = prlm.role_list_id
99: AND prlm.project_role_id = roles.project_role_id

Line 159: (p_pa_project_id pa_projects.project_id%type)

155:
156: --needed to get the field values associated to a AMG message
157:
158: CURSOR l_amg_project_csr
159: (p_pa_project_id pa_projects.project_id%type)
160: IS
161: SELECT segment1,COMPLETION_DATE
162: FROM pa_projects p
163: WHERE p.project_id = p_pa_project_id;

Line 162: FROM pa_projects p

158: CURSOR l_amg_project_csr
159: (p_pa_project_id pa_projects.project_id%type)
160: IS
161: SELECT segment1,COMPLETION_DATE
162: FROM pa_projects p
163: WHERE p.project_id = p_pa_project_id;
164:
165: BEGIN
166:

Line 437: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

433: , p_validate_only => FND_API.G_FALSE -- p_validate_only
434: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
435: , p_debug_mode => 'N' -- p_debug_mode
436: , p_object_id => p_project_id -- p_object_id
437: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
438: , p_project_role_id => v_project_role_id -- p_project_role_id
439: , p_project_role_type => NULL -- p_project_role_type
440: , p_RESOURCE_TYPE_ID => 101 -- p_RESOURCE_TYPE_ID
441: , p_resource_source_id => v_person_id -- p_resource_source_id

Line 568: (p_pa_project_id pa_projects.project_id%type)

564:
565: --needed to get the field values associated to a AMG message
566:
567: CURSOR l_amg_project_csr
568: (p_pa_project_id pa_projects.project_id%type)
569: IS
570: SELECT segment1
571: FROM pa_projects p
572: WHERE p.project_id = p_pa_project_id;

Line 571: FROM pa_projects p

567: CURSOR l_amg_project_csr
568: (p_pa_project_id pa_projects.project_id%type)
569: IS
570: SELECT segment1
571: FROM pa_projects p
572: WHERE p.project_id = p_pa_project_id;
573:
574: p_multiple_task_msg VARCHAR2(1) := 'T';
575:

Line 586: PA_PROJECTS_ALL ppa,

582: CURSOR l_valid_category_csr (c_project_id NUMBER, c_class_category VARCHAR2)
583: IS
584: SELECT 'Y'
585: FROM PA_VALID_CATEGORIES_V vc,
586: PA_PROJECTS_ALL ppa,
587: PA_PROJECT_TYPES_ALL ppta
588: WHERE ppa.project_id = c_project_id
589: AND ppa.project_type = ppta.project_type
590: AND nvl(ppa.org_id, -99) = nvl(ppta.org_id, -99)

Line 605: PA_PROJECTS_ALL PPA

601: SELECT 'Y'
602: FROM PA_CLASS_CATEGORIES cc,
603: PA_VALID_CATEGORIES vc,
604: PA_PROJECT_TYPES_ALL PPTA,
605: PA_PROJECTS_ALL PPA
606: WHERE PPA.PROJECT_ID = c_project_id
607: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
608: -- AND nvl(PPA.ORG_ID, -99) = nvl(PPTA.ORG_ID, -99) - R12: Bug 4364092
609: AND PPA.ORG_ID = PPTA.ORG_ID

Line 627: WHERE CC.OBJECT_TYPE = 'PA_PROJECTS'

623: WHERE EXISTS
624: (
625: SELECT 'Y'
626: FROM PA_CLASS_CATEGORIES cc
627: WHERE CC.OBJECT_TYPE = 'PA_PROJECTS'
628: AND CC.ALL_TYPES_VALID_FLAG = 'Y'
629: AND TRUNC(SYSDATE) BETWEEN TRUNC(CC.START_DATE_ACTIVE)
630: AND TRUNC(NVL(CC.END_DATE_ACTIVE, SYSDATE))
631: AND cc.CLASS_CATEGORY = c_class_category

Line 880: ,'PA_PROJECTS'

876: ,p_class_categories(i).class_category
877: ,p_class_categories(i).class_code
878: ,l_code_percentage
879: ,p_project_id
880: ,'PA_PROJECTS'
881: ,sysdate
882: ,fnd_global.user_id
883: ,sysdate
884: ,fnd_global.user_id

Line 1010: ,p_project_rec IN pa_projects%rowtype

1006: -- 10_dec-1996 L. de Werker Enabled the use of task addresses
1007: -- 09-01-2006 vkadimes Changes are tagged with Bug Number 4689326.
1008: PROCEDURE add_task_round_one
1009: (p_return_status OUT NOCOPY VARCHAR2 -- 4537865 Added nocopy hint
1010: ,p_project_rec IN pa_projects%rowtype
1011: ,p_task_rec IN pa_project_pub.task_in_rec_type
1012: ,p_project_type_class_code IN pa_project_types.project_type_class_code%type
1013: ,p_service_type_code IN pa_project_types.service_type_code%type
1014: ,p_task_id OUT NOCOPY NUMBER ) -- 4537865 Added nocopy hint

Line 1076: l_project_rate_type PA_PROJECTS.PROJECT_RATE_TYPE%type ; --bug2170388

1072: l_return_msg varchar2(2000);
1073: l_validate_status varchar2(1);
1074: --end bug 6153503
1075: l_allow_cross_charge_flag VARCHAR2(1);
1076: l_project_rate_type PA_PROJECTS.PROJECT_RATE_TYPE%type ; --bug2170388
1077: l_project_rate_date DATE;
1078: l_actual_start_date DATE;
1079: l_actual_finish_date DATE;
1080: l_early_start_date DATE;

Line 1165: (p_pa_project_id pa_projects.project_id%type)

1161:
1162: --needed to get the field values associated to a AMG message
1163:
1164: CURSOR l_amg_project_csr
1165: (p_pa_project_id pa_projects.project_id%type)
1166: IS
1167: SELECT segment1
1168: FROM pa_projects p
1169: WHERE p.project_id = p_pa_project_id;

Line 1168: FROM pa_projects p

1164: CURSOR l_amg_project_csr
1165: (p_pa_project_id pa_projects.project_id%type)
1166: IS
1167: SELECT segment1
1168: FROM pa_projects p
1169: WHERE p.project_id = p_pa_project_id;
1170:
1171: --needed to get the default field values
1172:

Line 1174: (p_pa_project_id pa_projects.project_id%type)

1170:
1171: --needed to get the default field values
1172:
1173: CURSOR l_default_project_csr
1174: (p_pa_project_id pa_projects.project_id%type)
1175: IS
1176: SELECT allow_cross_charge_flag,
1177: project_rate_date,
1178: project_rate_type,

Line 1230: FROM pa_projects p

1226: split_cost_from_workplan_flag,
1227: split_cost_from_bill_flag
1228: --Sakthi Structure
1229: */
1230: FROM pa_projects p
1231: WHERE p.project_id = p_pa_project_id;
1232:
1233: -- Fix for Bug # 1335417
1234: -- needed for update of Fixed Date( p_cost_ind_sch_fixed_date)

Line 1246: FROM pa_projects_all

1242: --Bug 3279981
1243: --The revenue acrual method for the task needs to be defaulted from the (new) project
1244: CURSOR cur_get_rev_acc_mth IS
1245: SELECT revenue_accrual_method
1246: FROM pa_projects_all
1247: WHERE project_id = p_project_rec.project_id;
1248:
1249: CURSOR cur_get_inv_mth IS
1250: SELECT invoice_method

Line 1251: FROM pa_projects_all

1247: WHERE project_id = p_project_rec.project_id;
1248:
1249: CURSOR cur_get_inv_mth IS
1250: SELECT invoice_method
1251: FROM pa_projects_all
1252: WHERE project_id = p_project_rec.project_id;
1253:
1254: CURSOR cur_get_def_top_task_cust IS
1255: SELECT customer_id

Line 2640: ,p_project_rec IN pa_projects%rowtype

2636: -- 28-MAY-1999 ODEO Fixed the three bugs mentioned in header
2637: --
2638: PROCEDURE add_task_round_two
2639: (p_return_status OUT NOCOPY VARCHAR2 -- 4537865 Added nocopy hint
2640: ,p_project_rec IN pa_projects%rowtype
2641: ,p_task_id IN NUMBER
2642: ,p_task_rec IN pa_project_pub.task_in_rec_type
2643: --Project Structures
2644: ,p_ref_task_id IN NUMBER

Line 2715: (p_pa_project_id pa_projects.project_id%type)

2711:
2712: --needed to get the field values associated to a AMG message
2713:
2714: CURSOR l_amg_project_csr
2715: (p_pa_project_id pa_projects.project_id%type)
2716: IS
2717: SELECT segment1
2718: FROM pa_projects p
2719: WHERE p.project_id = p_pa_project_id;

Line 2718: FROM pa_projects p

2714: CURSOR l_amg_project_csr
2715: (p_pa_project_id pa_projects.project_id%type)
2716: IS
2717: SELECT segment1
2718: FROM pa_projects p
2719: WHERE p.project_id = p_pa_project_id;
2720:
2721: CURSOR l_amg_task_csr
2722: (p_pa_task_id pa_tasks.task_id%type)

Line 3391: pa_projects

3387:
3388: CURSOR c_projects_csr IS
3389: SELECT project_id
3390: FROM
3391: pa_projects
3392: WHERE
3393: pm_project_reference = p_pm_project_reference;
3394:
3395: l_project_rec c_projects_csr%ROWTYPE;

Line 3482: FROM pa_projects

3478:
3479: CURSOR l_project_id_csr
3480: IS
3481: SELECT 'X'
3482: FROM pa_projects
3483: where project_id = p_pa_project_id;
3484:
3485: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_projref_to_id';
3486: l_project_id NUMBER ;

Line 3632: FROM pa_projects

3628:
3629: CURSOR l_project_id_csr
3630: IS
3631: SELECT 'X'
3632: FROM pa_projects
3633: where project_id = p_pa_project_id;
3634:
3635: CURSOR l_task_id_csr
3636: IS

Line 3649: (p_pa_project_id pa_projects.project_id%type)

3645: l_dummy VARCHAR2(1);
3646: --needed to get the field values associated to a AMG message
3647:
3648: CURSOR l_amg_project_csr
3649: (p_pa_project_id pa_projects.project_id%type)
3650: IS
3651: SELECT segment1
3652: FROM pa_projects p
3653: WHERE p.project_id = p_pa_project_id;

Line 3652: FROM pa_projects p

3648: CURSOR l_amg_project_csr
3649: (p_pa_project_id pa_projects.project_id%type)
3650: IS
3651: SELECT segment1
3652: FROM pa_projects p
3653: WHERE p.project_id = p_pa_project_id;
3654:
3655: l_amg_segment1 VARCHAR2(25);
3656:

Line 3855: FROM pa_projects

3851:
3852: CURSOR l_project_id_csr
3853: IS
3854: SELECT 'X'
3855: FROM pa_projects
3856: where project_id = p_pa_project_id;
3857:
3858: CURSOR l_task_id_csr
3859: IS

Line 3894: (p_pa_project_id pa_projects.project_id%type)

3890: l_dummy VARCHAR2(1);
3891: --needed to get the field values associated to a AMG message
3892:
3893: CURSOR l_amg_project_csr
3894: (p_pa_project_id pa_projects.project_id%type)
3895: IS
3896: SELECT segment1
3897: FROM pa_projects p
3898: WHERE p.project_id = p_pa_project_id;

Line 3897: FROM pa_projects p

3893: CURSOR l_amg_project_csr
3894: (p_pa_project_id pa_projects.project_id%type)
3895: IS
3896: SELECT segment1
3897: FROM pa_projects p
3898: WHERE p.project_id = p_pa_project_id;
3899:
3900: l_amg_segment1 VARCHAR2(25);
3901: --Added by rtarway for BUG 3919800

Line 4548: (p_pa_project_id pa_projects.project_id%type)

4544:
4545: --needed to get the field values associated to a AMG message
4546:
4547: CURSOR l_amg_project_csr
4548: (p_pa_project_id pa_projects.project_id%type)
4549: IS
4550: SELECT segment1
4551: FROM pa_projects p
4552: WHERE p.project_id = p_pa_project_id;

Line 4551: FROM pa_projects p

4547: CURSOR l_amg_project_csr
4548: (p_pa_project_id pa_projects.project_id%type)
4549: IS
4550: SELECT segment1
4551: FROM pa_projects p
4552: WHERE p.project_id = p_pa_project_id;
4553:
4554: CURSOR l_amg_task_csr
4555: (p_pa_task_id pa_tasks.task_id%type)

Line 5074: FROM pa_projects

5070: IS
5071: CURSOR l_get_project_info_csr (l_project_id IN NUMBER)
5072: IS
5073: SELECT project_type,pm_project_reference
5074: FROM pa_projects
5075: WHERE project_id = l_project_id;
5076:
5077: /* Added for bug#2666913 to get the project type*/
5078: CURSOR l_get_project_type_info_csr (l_project_id IN NUMBER)

Line 5081: FROM pa_project_types pt, pa_projects p

5077: /* Added for bug#2666913 to get the project type*/
5078: CURSOR l_get_project_type_info_csr (l_project_id IN NUMBER)
5079: IS
5080: SELECT project_type_class_code
5081: FROM pa_project_types pt, pa_projects p
5082: WHERE p.project_id = l_project_id
5083: and p.project_type = pt.project_type;
5084:
5085:

Line 5126: FROM pa_projects

5122:
5123: CURSOR l_project_date_csr (l_project_id NUMBER )
5124: IS
5125: SELECT trunc(start_date) start_date,trunc(completion_date) completion_date -- Bug Fix 4705139
5126: FROM pa_projects
5127: WHERE project_id = l_project_id;
5128:
5129: CURSOR l_top_task_csr (p_task_id NUMBER)
5130: IS

Line 5228: (p_pa_project_id pa_projects.project_id%type)

5224:
5225: --needed to get the field values associated to a AMG message
5226:
5227: CURSOR l_amg_project_csr
5228: (p_pa_project_id pa_projects.project_id%type)
5229: IS
5230: SELECT segment1
5231: FROM pa_projects p
5232: WHERE p.project_id = p_pa_project_id;

Line 5231: FROM pa_projects p

5227: CURSOR l_amg_project_csr
5228: (p_pa_project_id pa_projects.project_id%type)
5229: IS
5230: SELECT segment1
5231: FROM pa_projects p
5232: WHERE p.project_id = p_pa_project_id;
5233:
5234: CURSOR l_amg_task_csr
5235: (p_pa_task_id pa_tasks.task_id%type)

Line 6941: FROM PA_PROJECTS

6937: BEGIN
6938: IF p_pa_project_id IS NOT NULL THEN
6939: SELECT PROJECT_TYPE
6940: INTO l_project_type2
6941: FROM PA_PROJECTS
6942: WHERE PROJECT_ID = p_pa_project_id;
6943: ELSE
6944: SELECT PROJECT_TYPE
6945: INTO l_project_type2

Line 6946: FROM PA_PROJECTS

6942: WHERE PROJECT_ID = p_pa_project_id;
6943: ELSE
6944: SELECT PROJECT_TYPE
6945: INTO l_project_type2
6946: FROM PA_PROJECTS
6947: WHERE PROJECT_ID IN (SELECT PROJECT_ID
6948: FROM PA_TASKS
6949: WHERE TASK_ID = p_pa_task_id);
6950: END IF;

Line 9262: (p_pa_project_id pa_projects.project_id%type)

9258:
9259: --needed to get the field values associated to a AMG message
9260:
9261: CURSOR l_amg_project_csr
9262: (p_pa_project_id pa_projects.project_id%type)
9263: IS
9264: SELECT segment1
9265: FROM pa_projects p
9266: WHERE p.project_id = p_pa_project_id;

Line 9265: FROM pa_projects p

9261: CURSOR l_amg_project_csr
9262: (p_pa_project_id pa_projects.project_id%type)
9263: IS
9264: SELECT segment1
9265: FROM pa_projects p
9266: WHERE p.project_id = p_pa_project_id;
9267:
9268: CURSOR l_amg_task_csr
9269: (p_pa_task_id pa_tasks.task_id%type)

Line 9920: FROM pa_projects

9916:
9917: CURSOR l_lock_rows_csr( p_project_id NUMBER)
9918: IS
9919: SELECT 'x'
9920: FROM pa_projects
9921: WHERE project_id = p_project_id
9922: FOR UPDATE NOWAIT;
9923:
9924: --needed to get the field values associated to a AMG message

Line 9927: (p_pa_project_id pa_projects.project_id%type)

9923:
9924: --needed to get the field values associated to a AMG message
9925:
9926: CURSOR l_amg_project_csr
9927: (p_pa_project_id pa_projects.project_id%type)
9928: IS
9929: SELECT segment1
9930: FROM pa_projects p
9931: WHERE p.project_id = p_pa_project_id;

Line 9930: FROM pa_projects p

9926: CURSOR l_amg_project_csr
9927: (p_pa_project_id pa_projects.project_id%type)
9928: IS
9929: SELECT segment1
9930: FROM pa_projects p
9931: WHERE p.project_id = p_pa_project_id;
9932:
9933: l_amg_segment1 VARCHAR2(25);
9934:

Line 10389: (p_pa_project_id pa_projects.project_id%type)

10385: l_assignment_id NUMBER;
10386: --needed to get the field values associated to a AMG message
10387:
10388: CURSOR l_amg_project_csr
10389: (p_pa_project_id pa_projects.project_id%type)
10390: IS
10391: SELECT segment1,COMPLETION_DATE
10392: FROM pa_projects p
10393: WHERE p.project_id = p_pa_project_id;

Line 10392: FROM pa_projects p

10388: CURSOR l_amg_project_csr
10389: (p_pa_project_id pa_projects.project_id%type)
10390: IS
10391: SELECT segment1,COMPLETION_DATE
10392: FROM pa_projects p
10393: WHERE p.project_id = p_pa_project_id;
10394:
10395: BEGIN
10396:

Line 10516: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

10512: , p_validate_only => FND_API.G_FALSE -- p_validate_only
10513: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
10514: , p_debug_mode => 'N' -- p_debug_mode
10515: , p_object_id => p_project_id -- p_object_id
10516: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
10517: , p_project_role_id => v_project_role_id -- p_project_role_id
10518: , p_project_role_type => NULL -- p_project_role_type
10519: , p_RESOURCE_TYPE_ID => 112 -- p_RESOURCE_TYPE_ID
10520: , p_resource_source_id => v_person_id -- p_resource_source_id

Line 10540: PA_PROJECTS_MAINT_PUB.CREATE_ORG_ROLE(

10536: , x_msg_count => x_msg_count -- x_msg_count
10537: , x_msg_data => x_msg_data -- x_msg_data
10538: );
10539: */
10540: PA_PROJECTS_MAINT_PUB.CREATE_ORG_ROLE(
10541: p_api_version => 1.0 -- p_api_version
10542: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
10543: , p_commit => FND_API.G_FALSE -- p_commit
10544: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 10548: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

10544: , p_validate_only => FND_API.G_FALSE -- p_validate_only
10545: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
10546: , p_debug_mode => 'N' -- p_debug_mode
10547: , p_object_id => p_project_id -- p_object_id
10548: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
10549: , p_project_role_id => v_project_role_id -- p_project_role_id
10550: , p_project_role_type => NULL -- p_project_role_type
10551: , p_RESOURCE_TYPE_ID => 112 -- p_RESOURCE_TYPE_ID
10552: , p_resource_source_id => v_person_id -- p_resource_source_id

Line 10757: FROM pa_projects

10753:
10754: CURSOR l_prj_labor_sch_type_csr(p_pa_project_id VARCHAR2)
10755: IS
10756: SELECT labor_sch_type
10757: FROM pa_projects
10758: where project_id = p_pa_project_id;
10759:
10760: CURSOR l_tsk_lb_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
10761: IS

Line 10770: FROM pa_projects

10766:
10767: CURSOR l_prj_nl_sch_type_csr(p_pa_project_id VARCHAR2)
10768: IS
10769: SELECT non_labor_sch_type
10770: FROM pa_projects
10771: where project_id = p_pa_project_id;
10772:
10773: CURSOR l_tsk_nl_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
10774: IS

Line 10780: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)

10776: FROM pa_tasks
10777: where project_id = p_pa_project_id
10778: and task_id = p_pa_task_id;
10779:
10780: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
10781: IS
10782: SELECT segment1
10783: FROM pa_projects p
10784: WHERE p.project_id = p_pa_project_id;

Line 10783: FROM pa_projects p

10779:
10780: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
10781: IS
10782: SELECT segment1
10783: FROM pa_projects p
10784: WHERE p.project_id = p_pa_project_id;
10785:
10786:
10787:

Line 10982: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa

10978: --R12: Bug 4363092 - removed nvl for org_id in below cursor
10979: CURSOR l_emp_rate_sch_id_csr( p_emp_bill_rate_schedule_id NUMBER)
10980: IS
10981: SELECT 'x'
10982: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
10983: WHERE brs.bill_rate_sch_id = p_emp_bill_rate_schedule_id
10984: AND pa.project_id=p_pa_project_id
10985: and brs.schedule_type = 'EMPLOYEE'
10986: AND ( pa.multi_currency_BILLING_flag='Y'

Line 11001: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa

10997: --R12: Bug 4363092 - removed nvl for org_id in below cursor
10998: CURSOR l_job_rate_sch_id_csr( p_job_bill_rate_schedule_id NUMBER)
10999: IS
11000: SELECT 'x'
11001: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa
11002: WHERE bill_rate_sch_id = p_job_bill_rate_schedule_id
11003: AND brs.job_group_id=pt.bill_job_group_id
11004: and brs.schedule_type = 'JOB'
11005: AND pa.project_type=pt.project_type

Line 11023: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa

11019: --R12: Bug 4363092 - removed nvl for org_id in below cursor
11020: CURSOR l_nl_org_sch_id_csr( p_nl_bill_rate_org_id NUMBER,p_non_lab_std_bill_rt_sch_id NUMBER)
11021: IS
11022: SELECT 'x'
11023: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
11024: WHERE brs.organization_id = p_nl_bill_rate_org_id
11025: AND bill_rate_sch_id = p_non_lab_std_bill_rt_sch_id
11026: and brs.schedule_type = 'NON-LABOR'
11027: and (brs.schedule_type <> 'JOB'

Line 11043: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)

11039: ))
11040: AND pa.project_id=p_pa_project_id;
11041:
11042:
11043: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
11044: IS
11045: SELECT segment1
11046: FROM pa_projects p
11047: WHERE p.project_id = p_pa_project_id;

Line 11046: FROM pa_projects p

11042:
11043: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
11044: IS
11045: SELECT segment1
11046: FROM pa_projects p
11047: WHERE p.project_id = p_pa_project_id;
11048:
11049: CURSOR get_lab_disc_reason_code_csr(p_labor_disc_reason_code VARCHAR2)
11050: IS

Line 11930: from pa_projects_all

11926: valid_def_ttsk_cust VARCHAR2(1) :='N';
11927:
11928: cursor project_data is
11929: select enable_top_task_customer_flag
11930: from pa_projects_all
11931: where project_id=p_project_id;
11932:
11933: l_enable_tt_cust_flag varchar2(1) :='N';
11934: l_cust_count number;