APPS.PA_PROJECT_PVT dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 8190: FROM pa_std_bill_rate_schedules_all

8186: /*No data found is already handled in Validate_Schedule_Values*/
8187:
8188: BEGIN
8189: SELECT std_bill_rate_schedule INTO l_std_bill_rate_schedule
8190: FROM pa_std_bill_rate_schedules_all
8191: WHERE bill_rate_sch_id=p_non_lab_std_bill_rt_sch_id;
8192:
8193: --bug 2955326
8194: /*

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'