eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLAN_REVENUE dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 46: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2) AS
44: Cursor c_rule is
45: SELECT b.rate,b.markup_percentage,b.bill_rate_unit,b.rate_currency_code
46: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
47: WHERE sch.bill_rate_sch_id = p_res_class_rate_sch_id
48: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
49: AND sch.schedule_type = 'RESOURCE_CLASS'
50: AND trunc(p_item_date) BETWEEN trunc(b.start_date_active) AND trunc(NVL(b.end_date_active ,p_item_date))

Line 59: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,

55: the Organization and resource Class in the above cursor*/
56:
57: cursor c_parent_rule (p_proj_org_version_id IN NUMBER) is
58: SELECT b.rate,b.markup_percentage,b.bill_rate_unit,b.rate_currency_code
59: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,
60: ( select organization_id_parent PARENT_ORGANIZATION_ID,level parent_level
61: from per_org_structure_elements
62: where org_structure_version_id = p_proj_org_version_id
63: connect by prior organization_id_parent=organization_id_child

Line 2139: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2135: ,DECODE(p_uom,b.bill_rate_unit,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_cost_rate_multiplier,1)
2136: * p_quantity, b.rate_currency_code),null)
2137: ) r_cost,
2138: DECODE(p_uom,'DOLLARS', b.rate_currency_code,b.rate_currency_code) rate_currency_code
2139: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2140: WHERE sch.bill_rate_sch_id=p_cost_res_class_rate_sch_id
2141: AND sch.bill_rate_sch_id=b.bill_rate_sch_id
2142: AND b.resource_class_code = p_resource_class
2143: AND sch.schedule_type = 'RESOURCE_CLASS'

Line 2495: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2491: ) r_revenue,
2492: DECODE(p_uom,'DOLLARS',l_inter_txn_curr_code,DECODE(p_uom,b.bill_rate_unit,decode(b.rate,null,l_inter_txn_curr_code,b.rate_currency_code),l_inter_txn_curr_code) ) rate_currency_code,
2493: -- DECODE(p_uom,'DOLLARS', b.rate_currency_code,b.rate_currency_code ) rate_currency_code, --4194214
2494: DECODE (p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,decode(b.rate,null,b.markup_percentage,NULL),b.markup_percentage)) markup
2495: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2496: WHERE sch.bill_rate_sch_id=p_rev_res_class_rate_sch_id
2497: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2498: AND b.resource_class_code = p_resource_class
2499: AND sch.schedule_type = 'RESOURCE_CLASS'

Line 2745: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;

2741: l_raw_cost NUMBER;
2742: l_true BOOLEAN :=FALSE;
2743: l_bill_txn_curr_code VARCHAR2(30);
2744: -- Added for bug 5952621
2745: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2746: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
2747:
2748: /* Bug 8407306 */
2749: l_job_bl_rate NUMBER;

Line 2778: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2774: ) r_revenue,
2775: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2776: p_txn_currency_code) ) rate_currency_code, -- 4194214
2777: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2778: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2779: WHERE sch.bill_rate_sch_id=p_plan_rev_emp_rate_sch_id
2780: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2781: AND sch.schedule_type = 'EMPLOYEE'
2782: AND b.person_id = p_person_id

Line 2802: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b --, per_assignments_f pa

2798: ) r_revenue,
2799: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2800: p_txn_currency_code) ) rate_currency_code, -- 4194214
2801: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2802: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b --, per_assignments_f pa
2803: WHERE sch.bill_rate_sch_id = p_plan_rev_job_rate_sch_id
2804: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2805: AND sch.schedule_type = 'JOB'
2806: AND b.job_id = l_dest_job_id -- p_job_id Modified for bug 5952621

Line 2825: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2821: ) r_revenue,
2822: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2823: p_txn_currency_code) ) rate_currency_code, -- 4194214
2824: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2825: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2826: WHERE sch.bill_rate_sch_id = p_plan_rev_nlr_rate_sch_id
2827: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2828: AND b.expenditure_type = p_expenditure_type
2829: AND b.non_labor_resource = p_non_labor_resource

Line 2849: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2845: ) r_revenue,
2846: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2847: p_txn_currency_code) ) rate_currency_code, -- 4194214
2848: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2849: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2850: WHERE sch.bill_rate_sch_id = p_plan_rev_nlr_rate_sch_id
2851: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2852: AND b.expenditure_type = p_expenditure_type
2853: AND sch.schedule_type = 'NON-LABOR'

Line 2998: from pa_std_bill_rate_schedules_all

2994: -- NO_DATA_FOUND exception. l_dest_job_id is set to p_job_id
2995: BEGIN
2996: select job_group_id
2997: into l_job_group_id
2998: from pa_std_bill_rate_schedules_all
2999: where bill_rate_sch_id = p_plan_rev_job_rate_sch_id;
3000: EXCEPTION
3001: When NO_DATA_FOUND Then
3002: l_job_group_id := NULL;