DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_PKG dependencies on PA_BILL_RATES_ALL

Line 173: select rate from PA_BILL_RATES_ALL

169: NVL(ppfo.Approved_Cost_Plan_Type_Flag ,'N') = 'Y' and
170: ppfo.Fin_Plan_Option_Level_Code = 'PLAN_TYPE';
171:
172: cursor get_cost_markup(p_rate_sch_id number) is
173: select rate from PA_BILL_RATES_ALL
174: WHERE bill_rate_sch_id = p_rate_sch_id AND
175: resource_class_code = 'FINANCIAL_ELEMENTS' and
176: trunc(Nvl(to_date(null,'YYYY.MM.DD'),start_date_active)) between trunc(start_date_active)
177: and trunc(nvl(end_date_active,Nvl(to_date(null,'YYYY.MM.DD'),start_date_active)));

Line 1046: select markup_percentage from PA_BILL_RATES_ALL

1042: NVL(ppfo.Approved_Cost_Plan_Type_Flag ,'N') = 'Y' and
1043: ppfo.Fin_Plan_Option_Level_Code = 'PLAN_TYPE';
1044:
1045: cursor get_cost_markup(p_rate_sch_id number) is
1046: select markup_percentage from PA_BILL_RATES_ALL
1047: WHERE bill_rate_sch_id = p_rate_sch_id AND
1048: resource_class_code = 'FINANCIAL_ELEMENTS' and
1049: trunc(to_date(p_From_Date)) between trunc(start_date_active)
1050: and trunc(nvl(end_date_active,to_date(p_From_Date)));