DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECT_TYPES

Line 1150: FROM pa_project_types ppt, pa_std_bill_rate_schedules brs

1146: SELECT ppt.baseline_funding_flag
1147: ,ppt.NON_LAB_STD_BILL_RT_SCH_ID
1148: ,brs.std_bill_rate_schedule
1149: ,brs.rate_sch_currency_code
1150: FROM pa_project_types ppt, pa_std_bill_rate_schedules brs
1151: WHERE ppt.project_type = p_project_type
1152: AND ppt.non_lab_std_bill_rt_sch_id = brs.bill_rate_sch_id(+);
1153:
1154: BEGIN

Line 1208: FROM pa_std_bill_rate_schedules_all br, pa_project_types p

1204: BEGIN
1205:
1206: SELECT 'Y' INTO lv_return_flag FROM DUAL
1207: WHERE EXISTS (SELECT p.project_type_id
1208: FROM pa_std_bill_rate_schedules_all br, pa_project_types p
1209: WHERE ( p.job_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1210: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))
1211: OR ( p.emp_bill_rate_schedule_id = br.BILL_RATE_SCH_ID
1212: AND NVL(p.org_id,-99) <> NVL(br.org_id,-99))