DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECT_TYPES

Line 1143: FROM pa_project_types ppt, pa_std_bill_rate_schedules brs

1139: SELECT ppt.baseline_funding_flag
1140: ,ppt.NON_LAB_STD_BILL_RT_SCH_ID
1141: ,brs.std_bill_rate_schedule
1142: ,brs.rate_sch_currency_code
1143: FROM pa_project_types ppt, pa_std_bill_rate_schedules brs
1144: WHERE ppt.project_type = p_project_type
1145: AND ppt.non_lab_std_bill_rt_sch_id = brs.bill_rate_sch_id(+);
1146:
1147: BEGIN

Line 1201: FROM pa_std_bill_rate_schedules_all br, pa_project_types p

1197: BEGIN
1198:
1199: SELECT 'Y' INTO lv_return_flag FROM DUAL
1200: WHERE EXISTS (SELECT p.project_type_id
1201: FROM pa_std_bill_rate_schedules_all br, pa_project_types p
1202: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1203: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1204: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1205: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))