APPS.PA_PROJECT_PVT dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 8529: FROM pa_std_bill_rate_schedules_all

8525: /*No data found is already handled in Validate_Schedule_Values*/
8526:
8527: BEGIN
8528: SELECT std_bill_rate_schedule INTO l_std_bill_rate_schedule
8529: FROM pa_std_bill_rate_schedules_all
8530: WHERE bill_rate_sch_id=p_non_lab_std_bill_rt_sch_id;
8531:
8532: --bug 2955326
8533: /*

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'