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 1167: (p_pa_project_id pa_projects.project_id%type)

1163: l_pa_parent_task_id number; /* Added for 12.2Payroll billing ER 11899223 */
1164: --needed to get the field values associated to a AMG message
1165:
1166: CURSOR l_amg_project_csr
1167: (p_pa_project_id pa_projects.project_id%type)
1168: IS
1169: SELECT segment1
1170: FROM pa_projects p
1171: WHERE p.project_id = p_pa_project_id;

Line 1170: FROM pa_projects p

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

Line 1176: (p_pa_project_id pa_projects.project_id%type)

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

Line 1232: FROM pa_projects p

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

Line 1248: FROM pa_projects_all

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

Line 1253: FROM pa_projects_all

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

Line 1676: /* select adj_on_std_inv into l_adj_on_std_inv from pa_projects_all where project_id =p_project_rec.project_id ;

1672:
1673: else
1674:
1675:
1676: /* select adj_on_std_inv into l_adj_on_std_inv from pa_projects_all where project_id =p_project_rec.project_id ;
1677: commented for bug 12659208*/
1678:
1679: l_adj_on_std_inv := NULL;
1680:

Line 2833: ,p_project_rec IN pa_projects%rowtype

2829: -- 28-MAY-1999 ODEO Fixed the three bugs mentioned in header
2830: --
2831: PROCEDURE add_task_round_two
2832: (p_return_status OUT NOCOPY VARCHAR2 -- 4537865 Added nocopy hint
2833: ,p_project_rec IN pa_projects%rowtype
2834: ,p_task_id IN NUMBER
2835: ,p_task_rec IN pa_project_pub.task_in_rec_type
2836: --Project Structures
2837: ,p_ref_task_id IN NUMBER

Line 2908: (p_pa_project_id pa_projects.project_id%type)

2904:
2905: --needed to get the field values associated to a AMG message
2906:
2907: CURSOR l_amg_project_csr
2908: (p_pa_project_id pa_projects.project_id%type)
2909: IS
2910: SELECT segment1
2911: FROM pa_projects p
2912: WHERE p.project_id = p_pa_project_id;

Line 2911: FROM pa_projects p

2907: CURSOR l_amg_project_csr
2908: (p_pa_project_id pa_projects.project_id%type)
2909: IS
2910: SELECT segment1
2911: FROM pa_projects p
2912: WHERE p.project_id = p_pa_project_id;
2913:
2914: CURSOR l_amg_task_csr
2915: (p_pa_task_id pa_tasks.task_id%type)

Line 3584: pa_projects

3580:
3581: CURSOR c_projects_csr IS
3582: SELECT project_id
3583: FROM
3584: pa_projects
3585: WHERE
3586: pm_project_reference = p_pm_project_reference;
3587:
3588: l_project_rec c_projects_csr%ROWTYPE;

Line 3675: FROM pa_projects

3671:
3672: CURSOR l_project_id_csr
3673: IS
3674: SELECT 'X'
3675: FROM pa_projects
3676: where project_id = p_pa_project_id;
3677:
3678: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_projref_to_id';
3679: l_project_id NUMBER ;

Line 3825: FROM pa_projects

3821:
3822: CURSOR l_project_id_csr
3823: IS
3824: SELECT 'X'
3825: FROM pa_projects
3826: where project_id = p_pa_project_id;
3827:
3828: CURSOR l_task_id_csr
3829: IS

Line 3842: (p_pa_project_id pa_projects.project_id%type)

3838: l_dummy VARCHAR2(1);
3839: --needed to get the field values associated to a AMG message
3840:
3841: CURSOR l_amg_project_csr
3842: (p_pa_project_id pa_projects.project_id%type)
3843: IS
3844: SELECT segment1
3845: FROM pa_projects p
3846: WHERE p.project_id = p_pa_project_id;

Line 3845: FROM pa_projects p

3841: CURSOR l_amg_project_csr
3842: (p_pa_project_id pa_projects.project_id%type)
3843: IS
3844: SELECT segment1
3845: FROM pa_projects p
3846: WHERE p.project_id = p_pa_project_id;
3847:
3848: l_amg_segment1 VARCHAR2(25);
3849:

Line 4048: FROM pa_projects

4044:
4045: CURSOR l_project_id_csr
4046: IS
4047: SELECT 'X'
4048: FROM pa_projects
4049: where project_id = p_pa_project_id;
4050:
4051: CURSOR l_task_id_csr
4052: IS

Line 4087: (p_pa_project_id pa_projects.project_id%type)

4083: l_dummy VARCHAR2(1);
4084: --needed to get the field values associated to a AMG message
4085:
4086: CURSOR l_amg_project_csr
4087: (p_pa_project_id pa_projects.project_id%type)
4088: IS
4089: SELECT segment1
4090: FROM pa_projects p
4091: WHERE p.project_id = p_pa_project_id;

Line 4090: FROM pa_projects p

4086: CURSOR l_amg_project_csr
4087: (p_pa_project_id pa_projects.project_id%type)
4088: IS
4089: SELECT segment1
4090: FROM pa_projects p
4091: WHERE p.project_id = p_pa_project_id;
4092:
4093: l_amg_segment1 VARCHAR2(25);
4094: --Added by rtarway for BUG 3919800

Line 4745: (p_pa_project_id pa_projects.project_id%type)

4741:
4742: --needed to get the field values associated to a AMG message
4743:
4744: CURSOR l_amg_project_csr
4745: (p_pa_project_id pa_projects.project_id%type)
4746: IS
4747: SELECT segment1
4748: FROM pa_projects p
4749: WHERE p.project_id = p_pa_project_id;

Line 4748: FROM pa_projects p

4744: CURSOR l_amg_project_csr
4745: (p_pa_project_id pa_projects.project_id%type)
4746: IS
4747: SELECT segment1
4748: FROM pa_projects p
4749: WHERE p.project_id = p_pa_project_id;
4750:
4751: CURSOR l_amg_task_csr
4752: (p_pa_task_id pa_tasks.task_id%type)

Line 5272: FROM pa_projects

5268: IS
5269: CURSOR l_get_project_info_csr (l_project_id IN NUMBER)
5270: IS
5271: SELECT project_type,pm_project_reference
5272: FROM pa_projects
5273: WHERE project_id = l_project_id;
5274:
5275: /* Added for bug#2666913 to get the project type*/
5276: CURSOR l_get_project_type_info_csr (l_project_id IN NUMBER)

Line 5279: FROM pa_project_types pt, pa_projects p

5275: /* Added for bug#2666913 to get the project type*/
5276: CURSOR l_get_project_type_info_csr (l_project_id IN NUMBER)
5277: IS
5278: SELECT project_type_class_code
5279: FROM pa_project_types pt, pa_projects p
5280: WHERE p.project_id = l_project_id
5281: and p.project_type = pt.project_type;
5282:
5283:

Line 5324: FROM pa_projects

5320:
5321: CURSOR l_project_date_csr (l_project_id NUMBER )
5322: IS
5323: SELECT trunc(start_date) start_date,trunc(completion_date) completion_date -- Bug Fix 4705139
5324: FROM pa_projects
5325: WHERE project_id = l_project_id;
5326:
5327: CURSOR l_top_task_csr (p_task_id NUMBER)
5328: IS

Line 5426: (p_pa_project_id pa_projects.project_id%type)

5422:
5423: --needed to get the field values associated to a AMG message
5424:
5425: CURSOR l_amg_project_csr
5426: (p_pa_project_id pa_projects.project_id%type)
5427: IS
5428: SELECT segment1
5429: FROM pa_projects p
5430: WHERE p.project_id = p_pa_project_id;

Line 5429: FROM pa_projects p

5425: CURSOR l_amg_project_csr
5426: (p_pa_project_id pa_projects.project_id%type)
5427: IS
5428: SELECT segment1
5429: FROM pa_projects p
5430: WHERE p.project_id = p_pa_project_id;
5431:
5432: CURSOR l_amg_task_csr
5433: (p_pa_task_id pa_tasks.task_id%type)

Line 7269: FROM PA_PROJECTS

7265: BEGIN
7266: IF p_pa_project_id IS NOT NULL THEN
7267: SELECT PROJECT_TYPE
7268: INTO l_project_type2
7269: FROM PA_PROJECTS
7270: WHERE PROJECT_ID = p_pa_project_id;
7271: ELSE
7272: SELECT PROJECT_TYPE
7273: INTO l_project_type2

Line 7274: FROM PA_PROJECTS

7270: WHERE PROJECT_ID = p_pa_project_id;
7271: ELSE
7272: SELECT PROJECT_TYPE
7273: INTO l_project_type2
7274: FROM PA_PROJECTS
7275: WHERE PROJECT_ID IN (SELECT PROJECT_ID
7276: FROM PA_TASKS
7277: WHERE TASK_ID = p_pa_task_id);
7278: END IF;

Line 9602: (p_pa_project_id pa_projects.project_id%type)

9598:
9599: --needed to get the field values associated to a AMG message
9600:
9601: CURSOR l_amg_project_csr
9602: (p_pa_project_id pa_projects.project_id%type)
9603: IS
9604: SELECT segment1
9605: FROM pa_projects p
9606: WHERE p.project_id = p_pa_project_id;

Line 9605: FROM pa_projects p

9601: CURSOR l_amg_project_csr
9602: (p_pa_project_id pa_projects.project_id%type)
9603: IS
9604: SELECT segment1
9605: FROM pa_projects p
9606: WHERE p.project_id = p_pa_project_id;
9607:
9608: CURSOR l_amg_task_csr
9609: (p_pa_task_id pa_tasks.task_id%type)

Line 10260: FROM pa_projects

10256:
10257: CURSOR l_lock_rows_csr( p_project_id NUMBER)
10258: IS
10259: SELECT 'x'
10260: FROM pa_projects
10261: WHERE project_id = p_project_id
10262: FOR UPDATE NOWAIT;
10263:
10264: --needed to get the field values associated to a AMG message

Line 10267: (p_pa_project_id pa_projects.project_id%type)

10263:
10264: --needed to get the field values associated to a AMG message
10265:
10266: CURSOR l_amg_project_csr
10267: (p_pa_project_id pa_projects.project_id%type)
10268: IS
10269: SELECT segment1
10270: FROM pa_projects p
10271: WHERE p.project_id = p_pa_project_id;

Line 10270: FROM pa_projects p

10266: CURSOR l_amg_project_csr
10267: (p_pa_project_id pa_projects.project_id%type)
10268: IS
10269: SELECT segment1
10270: FROM pa_projects p
10271: WHERE p.project_id = p_pa_project_id;
10272:
10273: l_amg_segment1 VARCHAR2(25);
10274:

Line 10733: (p_pa_project_id pa_projects.project_id%type)

10729: l_assignment_id NUMBER;
10730: --needed to get the field values associated to a AMG message
10731:
10732: CURSOR l_amg_project_csr
10733: (p_pa_project_id pa_projects.project_id%type)
10734: IS
10735: SELECT segment1,COMPLETION_DATE
10736: FROM pa_projects p
10737: WHERE p.project_id = p_pa_project_id;

Line 10736: FROM pa_projects p

10732: CURSOR l_amg_project_csr
10733: (p_pa_project_id pa_projects.project_id%type)
10734: IS
10735: SELECT segment1,COMPLETION_DATE
10736: FROM pa_projects p
10737: WHERE p.project_id = p_pa_project_id;
10738:
10739: BEGIN
10740:

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

10862: , p_validate_only => FND_API.G_FALSE -- p_validate_only
10863: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
10864: , p_debug_mode => 'N' -- p_debug_mode
10865: , p_object_id => p_project_id -- p_object_id
10866: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
10867: , p_project_role_id => v_project_role_id -- p_project_role_id
10868: , p_project_role_type => NULL -- p_project_role_type
10869: , p_RESOURCE_TYPE_ID => 112 -- p_RESOURCE_TYPE_ID
10870: , p_resource_source_id => v_person_id -- p_resource_source_id

Line 10890: PA_PROJECTS_MAINT_PUB.CREATE_ORG_ROLE(

10886: , x_msg_count => x_msg_count -- x_msg_count
10887: , x_msg_data => x_msg_data -- x_msg_data
10888: );
10889: */
10890: PA_PROJECTS_MAINT_PUB.CREATE_ORG_ROLE(
10891: p_api_version => 1.0 -- p_api_version
10892: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
10893: , p_commit => FND_API.G_FALSE -- p_commit
10894: , p_validate_only => FND_API.G_FALSE -- p_validate_only

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

10894: , p_validate_only => FND_API.G_FALSE -- p_validate_only
10895: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
10896: , p_debug_mode => 'N' -- p_debug_mode
10897: , p_object_id => p_project_id -- p_object_id
10898: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
10899: , p_project_role_id => v_project_role_id -- p_project_role_id
10900: , p_project_role_type => NULL -- p_project_role_type
10901: , p_RESOURCE_TYPE_ID => 112 -- p_RESOURCE_TYPE_ID
10902: , p_resource_source_id => v_person_id -- p_resource_source_id

Line 11107: FROM pa_projects

11103:
11104: CURSOR l_prj_labor_sch_type_csr(p_pa_project_id VARCHAR2)
11105: IS
11106: SELECT labor_sch_type
11107: FROM pa_projects
11108: where project_id = p_pa_project_id;
11109:
11110: CURSOR l_tsk_lb_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
11111: IS

Line 11120: FROM pa_projects

11116:
11117: CURSOR l_prj_nl_sch_type_csr(p_pa_project_id VARCHAR2)
11118: IS
11119: SELECT non_labor_sch_type
11120: FROM pa_projects
11121: where project_id = p_pa_project_id;
11122:
11123: CURSOR l_tsk_nl_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
11124: IS

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

11126: FROM pa_tasks
11127: where project_id = p_pa_project_id
11128: and task_id = p_pa_task_id;
11129:
11130: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
11131: IS
11132: SELECT segment1
11133: FROM pa_projects p
11134: WHERE p.project_id = p_pa_project_id;

Line 11133: FROM pa_projects p

11129:
11130: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
11131: IS
11132: SELECT segment1
11133: FROM pa_projects p
11134: WHERE p.project_id = p_pa_project_id;
11135:
11136:
11137:

Line 11332: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa

11328: --R12: Bug 4363092 - removed nvl for org_id in below cursor
11329: CURSOR l_emp_rate_sch_id_csr( p_emp_bill_rate_schedule_id NUMBER)
11330: IS
11331: SELECT 'x'
11332: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
11333: WHERE brs.bill_rate_sch_id = p_emp_bill_rate_schedule_id
11334: AND pa.project_id=p_pa_project_id
11335: and brs.schedule_type = 'EMPLOYEE'
11336: AND ( pa.multi_currency_BILLING_flag='Y'

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

11347: --R12: Bug 4363092 - removed nvl for org_id in below cursor
11348: CURSOR l_job_rate_sch_id_csr( p_job_bill_rate_schedule_id NUMBER)
11349: IS
11350: SELECT 'x'
11351: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa
11352: WHERE bill_rate_sch_id = p_job_bill_rate_schedule_id
11353: AND brs.job_group_id=pt.bill_job_group_id
11354: and brs.schedule_type = 'JOB'
11355: AND pa.project_type=pt.project_type

Line 11373: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa

11369: --R12: Bug 4363092 - removed nvl for org_id in below cursor
11370: CURSOR l_nl_org_sch_id_csr( p_nl_bill_rate_org_id NUMBER,p_non_lab_std_bill_rt_sch_id NUMBER)
11371: IS
11372: SELECT 'x'
11373: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
11374: WHERE brs.organization_id = p_nl_bill_rate_org_id
11375: AND bill_rate_sch_id = p_non_lab_std_bill_rt_sch_id
11376: and brs.schedule_type = 'NON-LABOR'
11377: and (brs.schedule_type <> 'JOB'

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

11389: ))
11390: AND pa.project_id=p_pa_project_id;
11391:
11392:
11393: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
11394: IS
11395: SELECT segment1
11396: FROM pa_projects p
11397: WHERE p.project_id = p_pa_project_id;

Line 11396: FROM pa_projects p

11392:
11393: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)
11394: IS
11395: SELECT segment1
11396: FROM pa_projects p
11397: WHERE p.project_id = p_pa_project_id;
11398:
11399: CURSOR get_lab_disc_reason_code_csr(p_labor_disc_reason_code VARCHAR2)
11400: IS

Line 12293: from pa_projects_all

12289: valid_def_ttsk_cust VARCHAR2(1) :='N';
12290:
12291: cursor project_data is
12292: select enable_top_task_customer_flag
12293: from pa_projects_all
12294: where project_id=p_project_id;
12295:
12296: l_enable_tt_cust_flag varchar2(1) :='N';
12297: l_cust_count number;