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_REVENUE dependencies on PA_BILL_RATES_ALL

Line 140: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

136:
137: /* Added for MCB2 */
138: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
139: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
140: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
141:
142: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
143: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
144: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

Line 143: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

139: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
140: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
141:
142: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
143: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
144: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
145:
146: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
147: the revenue from client extension */

Line 580: FROM pa_bill_rates_all b

576: b.markup_percentage
577: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue,
578: l_rate_currency_code /* Added for MCB2 */,
579: l_markup_percentage /* Added for Asgmt overide */
580: FROM pa_bill_rates_all b
581: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
582: AND b.job_id = px_project_bill_job_id
583: AND trunc(NVL(l_labor_schdl_fixed_date, p_item_date)) + 0.99999 /* BUG#3118592 */
584: BETWEEN b.start_date_active

Line 774: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

770:
771: /* Added for MCB2 */
772: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
773: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
774: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
775:
776: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
777:
778: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

Line 778: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

774: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
775:
776: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
777:
778: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
779: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
780:
781: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
782: the revenue from client extension */

Line 1919: FROM pa_bill_rates_all b

1915: l_rate_currency_code /* Added for MCB2 */,
1916: l_markup_percentage, /* Added for Asgmt overide */
1917: l_amount_calculation_code,
1918: l_discount_percentage
1919: FROM pa_bill_rates_all b
1920: WHERE b.bill_rate_sch_id = l_emp_bill_rate_schedule_id
1921: AND b.person_id = p_person_id
1922: AND NVL(l_labor_schdl_fixed_date,p_item_date)
1923: BETWEEN b.start_date_active

Line 1958: FROM pa_bill_rates_all b

1954: l_rate_currency_code /* Added for MCB2 */,
1955: l_markup_percentage ,/* Added for Asgmt overide */
1956: l_amount_calculation_code,
1957: l_discount_percentage
1958: FROM pa_bill_rates_all b
1959: WHERE b.bill_rate_sch_id = l_emp_bill_rate_schedule_id
1960: AND b.person_id = p_person_id
1961: AND NVL(l_labor_schdl_fixed_date,p_item_date)
1962: BETWEEN b.start_date_active

Line 2008: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2004: b.rate_currency_code
2005: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue, l_amount_calculation_code,
2006: l_discount_percentage,
2007: l_rate_currency_code /*Rate added for bug 2636678 */
2008: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2009: WHERE ao.person_id = p_person_id
2010: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2011: AND b.job_id = ao.job_id(+)
2012: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

Line 2055: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t

2051: DECODE(l_discount_percentage,NULL,'B','O'),
2052: nvl(l_discount_percentage,l_labor_schdl_discnt)
2053: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
2054: l_amount_calculation_code,l_discount_percentage
2055: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2056: WHERE ao.person_id = p_person_id
2057: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2058: AND b.job_id = ao.job_id(+)
2059: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

Line 2104: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2100: INTO l_bill_rate,l_raw_revenue,
2101: l_rate_currency_code,
2102: l_amount_calculation_code,
2103: l_discount_percentage
2104: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2105: WHERE ao.person_id = p_person_id
2106: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2107: AND b.job_id = ao.job_id
2108: AND ao.project_id = p_project_id

Line 2147: FROM pa_bill_rates_all b -- per_assignments_f pa Commented for Bug 4398492 query made to refer base table

2143: INTO l_bill_rate,l_raw_revenue,
2144: l_rate_currency_code,
2145: l_amount_calculation_code,
2146: l_discount_percentage
2147: FROM pa_bill_rates_all b -- per_assignments_f pa Commented for Bug 4398492 query made to refer base table
2148: , per_all_assignments_f pa
2149: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2150: AND pa.person_id = p_person_id
2151: AND pa.primary_flag = 'Y'

Line 2188: FROM pa_bill_rates_all b

2184: INTO l_bill_rate,l_raw_revenue,
2185: l_rate_currency_code,
2186: l_amount_calculation_code,
2187: l_discount_percentage
2188: FROM pa_bill_rates_all b
2189: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2190: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */
2191: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2192: BETWEEN b.start_date_active

Line 2247: FROM pa_bill_rates_all b

2243: b.markup_percentage
2244: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue,
2245: l_rate_currency_code
2246: l_markup_percentage
2247: FROM pa_bill_rates_all b
2248: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2249: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id)
2250: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2251: BETWEEN b.start_date_active

Line 2396: l_rate_currency_code PA_BILL_RATES_all.rate_currency_code%TYPE;

2392: -- calling procedure has run successfully
2393: -- or encounter any error
2394: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
2395: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
2396: l_rate_currency_code PA_BILL_RATES_all.rate_currency_code%TYPE;
2397: l_denominator NUMBER;
2398: l_numerator NUMBER;
2399: l_status VARCHAR2(30);
2400:

Line 3327: FROM pa_bill_rates_all b

3323: * NVL(p_bill_rate_multiplier,1)
3324: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3325: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code,
3326: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3327: FROM pa_bill_rates_all b
3328: WHERE /*b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3329: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3330: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3331: AND b.expenditure_type = p_expenditure_type

Line 3357: FROM pa_bill_rates_all b2

3353: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3354: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3355: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3356: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3357: FROM pa_bill_rates_all b2
3358: WHERE /*b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3359: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3360: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id/*added for bug2690011*/
3361: AND b2.expenditure_type = p_expenditure_type

Line 3369: FROM pa_bill_rates_all b3

3365: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3366: AND NVL(trunc(b2.end_date_active),trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3367: AND NOT EXISTS
3368: (SELECT b3.rate
3369: FROM pa_bill_rates_all b3
3370: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3371: AND b3.bill_rate_organization_id =p_task_bill_rate_org_id commented for bug2690011*/
3372: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3373: AND b3.expenditure_type = p_expenditure_type

Line 3401: FROM pa_bill_rates_all b

3397: * NVL(p_bill_rate_multiplier,1)
3398: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3399: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code,
3400: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3401: FROM pa_bill_rates_all b
3402: WHERE/* b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3403: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3404: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3405: AND b.expenditure_type = p_expenditure_type

Line 3435: FROM pa_bill_rates_all b2

3431: * NVL(p_bill_rate_multiplier,1)
3432: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3433: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3434: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3435: FROM pa_bill_rates_all b2
3436: WHERE/* b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3437: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3438: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id/*added for bug2690011*/
3439: AND b2.expenditure_type = p_expenditure_type

Line 3447: FROM pa_bill_rates_all b3

3443: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3444: AND NVL(trunc(b2.end_date_active),trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3445: AND NOT EXISTS
3446: (SELECT b3.rate
3447: FROM pa_bill_rates_all b3
3448: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3449: AND b3.bill_rate_organization_id =p_task_bill_rate_org_id commented for bug2690011*/
3450: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3451: AND b3.expenditure_type = p_expenditure_type

Line 3780: FROM pa_bill_rates_all b

3776: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))
3777: ) trans_adjusted_amount,
3778: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code ,
3779: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3780: FROM pa_bill_rates_all b
3781: WHERE /*b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3782: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3783: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3784: AND b.expenditure_type = p_expenditure_type

Line 3813: FROM pa_bill_rates_all b2

3809: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100,
3810: b2.rate_currency_code))) trans_adjusted_amount,
3811: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3812: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3813: FROM pa_bill_rates_all b2
3814: WHERE /*b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3815: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3816: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id/*added for bug2690011*/
3817: AND b2.expenditure_type = p_expenditure_type

Line 3825: FROM pa_bill_rates_all b3

3821: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3822: AND NVL(trunc(b2.end_date_active), trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3823: AND NOT EXISTS
3824: (SELECT b3.rate
3825: FROM pa_bill_rates_all b3
3826: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3827: AND b3.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3828: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3829: AND b3.expenditure_type = p_expenditure_type

Line 3860: FROM pa_bill_rates_all b

3856: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100,
3857: b.rate_currency_code))) trans_adjusted_amount,
3858: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code ,
3859: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3860: FROM pa_bill_rates_all b
3861: WHERE /*b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3862: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3863: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3864: AND b.expenditure_type = p_expenditure_type

Line 3892: FROM pa_bill_rates_all b2

3888: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3889: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3890: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3891: NVL(l_rate_discount_pct,p_project_sch_discount)
3892: FROM pa_bill_rates_all b2
3893: WHERE /*b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3894: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3895: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id /*added for bug2690011*/
3896: AND b2.expenditure_type = p_expenditure_type

Line 3904: FROM pa_bill_rates_all b3

3900: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3901: AND NVL(trunc(b2.end_date_active),trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3902: AND NOT EXISTS
3903: (SELECT b3.rate
3904: FROM pa_bill_rates_all b3
3905: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3906: AND b3.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3907: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id /*added for bug2690011*/
3908: AND b3.expenditure_type = p_expenditure_type