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 589: FROM pa_bill_rates_all b

585: b.markup_percentage
586: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue,
587: l_rate_currency_code /* Added for MCB2 */,
588: l_markup_percentage /* Added for Asgmt overide */
589: FROM pa_bill_rates_all b
590: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
591: AND b.job_id = px_project_bill_job_id
592: AND trunc(NVL(l_labor_schdl_fixed_date, p_item_date)) + 0.99999 /* BUG#3118592 */
593: BETWEEN b.start_date_active

Line 783: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

779:
780: /* Added for MCB2 */
781: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
782: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
783: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
784:
785: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
786:
787: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */

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

783: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
784:
785: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
786:
787: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
788: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
789:
790: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
791: the revenue from client extension */

Line 1938: FROM pa_bill_rates_all b

1934: l_rate_currency_code /* Added for MCB2 */,
1935: l_markup_percentage, /* Added for Asgmt overide */
1936: l_amount_calculation_code,
1937: l_discount_percentage
1938: FROM pa_bill_rates_all b
1939: WHERE b.bill_rate_sch_id = l_emp_bill_rate_schedule_id
1940: AND b.person_id = p_person_id
1941: AND NVL(l_labor_schdl_fixed_date,p_item_date)
1942: BETWEEN b.start_date_active

Line 1977: FROM pa_bill_rates_all b

1973: l_rate_currency_code /* Added for MCB2 */,
1974: l_markup_percentage ,/* Added for Asgmt overide */
1975: l_amount_calculation_code,
1976: l_discount_percentage
1977: FROM pa_bill_rates_all b
1978: WHERE b.bill_rate_sch_id = l_emp_bill_rate_schedule_id
1979: AND b.person_id = p_person_id
1980: AND NVL(l_labor_schdl_fixed_date,p_item_date)
1981: BETWEEN b.start_date_active

Line 2027: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2023: b.rate_currency_code
2024: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue, l_amount_calculation_code,
2025: l_discount_percentage,
2026: l_rate_currency_code /*Rate added for bug 2636678 */
2027: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2028: WHERE ao.person_id = p_person_id
2029: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2030: AND b.job_id = ao.job_id /*modified for bug 9257637 */
2031: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */

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

2070: DECODE(l_discount_percentage,NULL,'B','O'),
2071: nvl(l_discount_percentage,l_labor_schdl_discnt)
2072: INTO l_bill_rate,l_raw_revenue,l_rate_currency_code,
2073: l_amount_calculation_code,l_discount_percentage
2074: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2075: WHERE ao.person_id = p_person_id
2076: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2077: AND b.job_id = ao.job_id
2078: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */

Line 2123: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao

2119: INTO l_bill_rate,l_raw_revenue,
2120: l_rate_currency_code,
2121: l_amount_calculation_code,
2122: l_discount_percentage
2123: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2124: WHERE ao.person_id = p_person_id
2125: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2126: AND b.job_id = ao.job_id
2127: AND ao.project_id = p_project_id

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

2162: INTO l_bill_rate,l_raw_revenue,
2163: l_rate_currency_code,
2164: l_amount_calculation_code,
2165: l_discount_percentage
2166: FROM pa_bill_rates_all b -- per_assignments_f pa Commented for Bug 4398492 query made to refer base table
2167: , per_all_assignments_f pa
2168: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2169: AND pa.person_id = p_person_id
2170: AND pa.primary_flag = 'Y'

Line 2208: FROM pa_bill_rates_all b

2204: INTO l_bill_rate,l_raw_revenue,
2205: l_rate_currency_code,
2206: l_amount_calculation_code,
2207: l_discount_percentage
2208: FROM pa_bill_rates_all b
2209: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2210: AND b.job_id = p_resource_job_id /* Bug 6058676 *//*modified for bug 9257637 */
2211: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2212: BETWEEN b.start_date_active

Line 2267: FROM pa_bill_rates_all b

2263: b.markup_percentage
2264: INTO l_bill_rate,l_raw_revenue,l_adjusted_rate,l_adjusted_revenue,
2265: l_rate_currency_code
2266: l_markup_percentage
2267: FROM pa_bill_rates_all b
2268: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2269: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id)
2270: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2271: BETWEEN b.start_date_active

Line 2416: l_rate_currency_code PA_BILL_RATES_all.rate_currency_code%TYPE;

2412: -- calling procedure has run successfully
2413: -- or encounter any error
2414: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
2415: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
2416: l_rate_currency_code PA_BILL_RATES_all.rate_currency_code%TYPE;
2417: l_denominator NUMBER;
2418: l_numerator NUMBER;
2419: l_status VARCHAR2(30);
2420:

Line 3353: FROM pa_bill_rates_all b

3349: * NVL(p_bill_rate_multiplier,1)
3350: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3351: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code,
3352: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3353: FROM pa_bill_rates_all b
3354: WHERE /*b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3355: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3356: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3357: AND b.expenditure_type = p_expenditure_type

Line 3383: FROM pa_bill_rates_all b2

3379: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3380: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3381: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3382: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3383: FROM pa_bill_rates_all b2
3384: WHERE /*b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3385: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3386: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id/*added for bug2690011*/
3387: AND b2.expenditure_type = p_expenditure_type

Line 3395: FROM pa_bill_rates_all b3

3391: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3392: AND NVL(trunc(b2.end_date_active),trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3393: AND NOT EXISTS
3394: (SELECT b3.rate
3395: FROM pa_bill_rates_all b3
3396: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3397: AND b3.bill_rate_organization_id =p_task_bill_rate_org_id commented for bug2690011*/
3398: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3399: AND b3.expenditure_type = p_expenditure_type

Line 3427: FROM pa_bill_rates_all b

3423: * NVL(p_bill_rate_multiplier,1)
3424: * (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))) trans_adjusted_revenue,
3425: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code,
3426: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3427: FROM pa_bill_rates_all b
3428: WHERE/* b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3429: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3430: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3431: AND b.expenditure_type = p_expenditure_type

Line 3461: FROM pa_bill_rates_all b2

3457: * NVL(p_bill_rate_multiplier,1)
3458: * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3459: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3460: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3461: FROM pa_bill_rates_all b2
3462: WHERE/* b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3463: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3464: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id/*added for bug2690011*/
3465: AND b2.expenditure_type = p_expenditure_type

Line 3473: FROM pa_bill_rates_all b3

3469: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3470: AND NVL(trunc(b2.end_date_active),trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3471: AND NOT EXISTS
3472: (SELECT b3.rate
3473: FROM pa_bill_rates_all b3
3474: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3475: AND b3.bill_rate_organization_id =p_task_bill_rate_org_id commented for bug2690011*/
3476: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3477: AND b3.expenditure_type = p_expenditure_type

Line 3806: FROM pa_bill_rates_all b

3802: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100, b.rate_currency_code))
3803: ) trans_adjusted_amount,
3804: DECODE(b.rate, NULL, l_mcb_currency_code, b.rate_currency_code) rate_currency_code ,
3805: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3806: FROM pa_bill_rates_all b
3807: WHERE /*b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3808: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3809: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3810: AND b.expenditure_type = p_expenditure_type

Line 3839: FROM pa_bill_rates_all b2

3835: * NVL(p_bill_rate_multiplier,1) * (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100,
3836: b2.rate_currency_code))) trans_adjusted_amount,
3837: DECODE(b2.rate, NULL, l_mcb_currency_code, b2.rate_currency_code) rate_currency_code,
3838: NVL(l_rate_discount_pct,p_project_sch_discount) discount_pct
3839: FROM pa_bill_rates_all b2
3840: WHERE /*b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3841: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3842: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id/*added for bug2690011*/
3843: AND b2.expenditure_type = p_expenditure_type

Line 3851: FROM pa_bill_rates_all b3

3847: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3848: AND NVL(trunc(b2.end_date_active), trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3849: AND NOT EXISTS
3850: (SELECT b3.rate
3851: FROM pa_bill_rates_all b3
3852: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3853: AND b3.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3854: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3855: AND b3.expenditure_type = p_expenditure_type

Line 3886: FROM pa_bill_rates_all b

3882: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_task_sch_discount)) / 100,
3883: b.rate_currency_code))) trans_adjusted_amount,
3884: DECODE(b.rate, NULL, p_proj_func_currency, b.rate_currency_code) rate_currency_code ,
3885: NVL(l_rate_discount_pct,p_task_sch_discount) discount_pct
3886: FROM pa_bill_rates_all b
3887: WHERE /*b.std_bill_rate_schedule = p_task_std_bill_rate_sch
3888: AND b.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3889: b.bill_rate_sch_id=l_task_std_bill_rate_sch_id/*added for bug2690011*/
3890: AND b.expenditure_type = p_expenditure_type

Line 3918: FROM pa_bill_rates_all b2

3914: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT((b2.rate * p_quantity)
3915: * NVL(p_bill_rate_multiplier,1)* (100 - NVL(l_rate_discount_pct,p_project_sch_discount)) / 100, b2.rate_currency_code))),
3916: DECODE(b2.rate, NULL, p_proj_func_currency, b2.rate_currency_code) rate_currency_code,
3917: NVL(l_rate_discount_pct,p_project_sch_discount)
3918: FROM pa_bill_rates_all b2
3919: WHERE /*b2.std_bill_rate_schedule = p_project_std_bill_rate_sch
3920: AND b2.bill_rate_organization_id = p_project_bill_rate_org_id commented for bug2690011*/
3921: b2.bill_rate_sch_id=l_proj_std_bill_rate_sch_id /*added for bug2690011*/
3922: AND b2.expenditure_type = p_expenditure_type

Line 3930: FROM pa_bill_rates_all b3

3926: BETWEEN trunc(b2.start_date_active) /* BUG#3118592 */
3927: AND NVL(trunc(b2.end_date_active),trunc(NVL(p_project_sch_date,p_expenditure_item_date))) /* BUG#3118592 */
3928: AND NOT EXISTS
3929: (SELECT b3.rate
3930: FROM pa_bill_rates_all b3
3931: WHERE /*b3.std_bill_rate_schedule = p_task_std_bill_rate_sch
3932: AND b3.bill_rate_organization_id = p_task_bill_rate_org_id commented for bug2690011*/
3933: b3.bill_rate_sch_id=l_task_std_bill_rate_sch_id /*added for bug2690011*/
3934: AND b3.expenditure_type = p_expenditure_type