APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_TYPES

Line 587: PA_PROJECT_TYPES_ALL ppta

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)
591: AND ppta.project_type_id = vc.object_type_id

Line 604: PA_PROJECT_TYPES_ALL PPTA,

600: (
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

Line 1012: ,p_project_type_class_code IN pa_project_types.project_type_class_code%type

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
1015: IS
1016:

Line 1013: ,p_service_type_code IN pa_project_types.service_type_code%type

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
1015: IS
1016:
1017: CURSOR l_customer_csr( p_project_id 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 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