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_NL_BILL_RATE_OVERRIDES

Line 2957: FROM pa_nl_bill_rate_overrides o

2953: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2954: * p_quantity , o.rate_currency_code)) r_revenue,
2955: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
2956: o.discount_percentage discount_pct
2957: FROM pa_nl_bill_rate_overrides o
2958: WHERE o.task_id = p_task_id
2959: AND o.expenditure_type = p_expenditure_type
2960: AND o.non_labor_resource = p_non_labor_resource
2961: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 2978: FROM pa_nl_bill_rate_overrides o

2974: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2975: * p_quantity, o.rate_currency_code)),
2976: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
2977: o.discount_percentage discount_pct
2978: FROM pa_nl_bill_rate_overrides o
2979: WHERE o.task_id = p_task_id
2980: AND o.expenditure_type = p_expenditure_type
2981: AND o.non_labor_resource is NULL
2982: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 2989: FROM pa_nl_bill_rate_overrides o3

2985: BETWEEN trunc(o.start_date_active) /* BUG#3118592 */
2986: AND trunc(NVL(o.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
2987: AND NOT EXISTS
2988: (SELECT o3.bill_rate
2989: FROM pa_nl_bill_rate_overrides o3
2990: WHERE o3.task_id = p_task_id
2991: AND o3.expenditure_type = p_expenditure_type
2992: AND o3.non_labor_resource = p_non_labor_resource
2993: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3011: FROM pa_nl_bill_rate_overrides o2

3007: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3008: * p_quantity, o2.rate_currency_code)),
3009: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3010: o2.discount_percentage discount_pct
3011: FROM pa_nl_bill_rate_overrides o2
3012: WHERE o2.project_id = p_project_id
3013: AND o2.expenditure_type = p_expenditure_type
3014: AND o2.non_labor_resource = p_non_labor_resource
3015: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3022: FROM pa_nl_bill_rate_overrides o3

3018: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3019: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3020: AND NOT EXISTS
3021: (SELECT o3.bill_rate
3022: FROM pa_nl_bill_rate_overrides o3
3023: WHERE o3.task_id = p_task_id
3024: AND o3.expenditure_type = p_expenditure_type
3025: AND l_called_process <> 1 /*Added for Doosan rate api change */
3026: AND (o3.bill_rate IS NULL OR p_uom_flag =1 ) /*Added for UOM enhancement */

Line 3043: FROM pa_nl_bill_rate_overrides o2

3039: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3040: * p_quantity, o2.rate_currency_code)) r_revenue,
3041: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3042: o2.discount_percentage discount_pct
3043: FROM pa_nl_bill_rate_overrides o2
3044: WHERE o2.project_id = p_project_id
3045: AND o2.expenditure_type = p_expenditure_type
3046: AND o2.non_labor_resource is NULL
3047: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3054: FROM pa_nl_bill_rate_overrides o3

3050: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3051: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3052: AND NOT EXISTS
3053: (SELECT o3.bill_rate
3054: FROM pa_nl_bill_rate_overrides o3
3055: WHERE o3.task_id = p_task_id
3056: AND o3.expenditure_type = p_expenditure_type
3057: AND l_called_process <> 1 /*Added for Doosan rate api change */
3058: AND (o3.bill_rate IS NULL OR p_uom_flag =1 ) /*Added for UOM enhancement */

Line 3064: FROM pa_nl_bill_rate_overrides o3

3060: BETWEEN trunc(o3.start_date_active) /* BUG#3118592 */
3061: AND trunc(NVL(o3.end_date_active,p_expenditure_item_date))) /* BUG#3118592 */
3062: AND NOT EXISTS
3063: (SELECT o3.bill_rate
3064: FROM pa_nl_bill_rate_overrides o3
3065: WHERE o3.project_id = p_project_id
3066: AND o3.expenditure_type = p_expenditure_type
3067: AND o3.non_labor_resource = p_non_labor_resource
3068: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3087: FROM pa_nl_bill_rate_overrides o

3083: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3084: * p_quantity, o.rate_currency_code)) r_revenue,
3085: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3086: o.discount_percentage discount_pct
3087: FROM pa_nl_bill_rate_overrides o
3088: WHERE o.task_id = p_task_id
3089: AND o.expenditure_type = p_expenditure_type
3090: AND o.non_labor_resource = p_non_labor_resource
3091: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3106: FROM pa_nl_bill_rate_overrides o

3102: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3103: * p_quantity, o.rate_currency_code)),
3104: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code ,
3105: o.discount_percentage discount_pct
3106: FROM pa_nl_bill_rate_overrides o
3107: WHERE o.task_id = p_task_id
3108: AND o.expenditure_type = p_expenditure_type
3109: AND o.non_labor_resource is NULL
3110: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3117: FROM pa_nl_bill_rate_overrides o3

3113: BETWEEN trunc(o.start_date_active) /* BUG#3118592 */
3114: AND trunc(NVL(o.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3115: AND NOT EXISTS
3116: (SELECT o3.bill_rate
3117: FROM pa_nl_bill_rate_overrides o3
3118: WHERE o3.task_id = p_task_id
3119: AND o3.expenditure_type = p_expenditure_type
3120: AND o3.non_labor_resource = p_non_labor_resource
3121: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3137: FROM pa_nl_bill_rate_overrides o2

3133: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3134: * p_quantity, o2.rate_currency_code)),
3135: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code ,
3136: o2.discount_percentage discount_pct
3137: FROM pa_nl_bill_rate_overrides o2
3138: WHERE o2.project_id = p_project_id
3139: AND o2.expenditure_type = p_expenditure_type
3140: AND o2.non_labor_resource = p_non_labor_resource
3141: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3148: FROM pa_nl_bill_rate_overrides o3

3144: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3145: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3146: AND NOT EXISTS
3147: (SELECT o3.bill_rate
3148: FROM pa_nl_bill_rate_overrides o3
3149: WHERE o3.task_id = p_task_id
3150: AND o3.expenditure_type = p_expenditure_type
3151: AND l_called_process <> 1 /*Added for Doosan rate api change */
3152: AND (o3.bill_rate IS NULL OR p_uom_flag =1 ) /*Added for UOM enhancement */

Line 3167: FROM pa_nl_bill_rate_overrides o2

3163: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3164: * p_quantity, o2.rate_currency_code)),
3165: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3166: o2.discount_percentage discount_pct
3167: FROM pa_nl_bill_rate_overrides o2
3168: WHERE o2.project_id = p_project_id
3169: AND o2.expenditure_type = p_expenditure_type
3170: AND o2.non_labor_resource is NULL
3171: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3178: FROM pa_nl_bill_rate_overrides o3

3174: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3175: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3176: AND NOT EXISTS
3177: (SELECT o3.bill_rate
3178: FROM pa_nl_bill_rate_overrides o3
3179: WHERE o3.task_id = p_task_id
3180: AND o3.expenditure_type = p_expenditure_type
3181: AND l_called_process <> 1 /*Added for Doosan rate api change */
3182: AND (o3.bill_rate IS NULL OR p_uom_flag =1 ) /*Added for UOM enhancement */

Line 3189: FROM pa_nl_bill_rate_overrides o3

3185: AND trunc(NVL(o3.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3186: )
3187: AND NOT EXISTS
3188: (SELECT o3.bill_rate
3189: FROM pa_nl_bill_rate_overrides o3
3190: WHERE o3.project_id = p_project_id
3191: AND o3.expenditure_type = p_expenditure_type
3192: AND o3.non_labor_resource = p_non_labor_resource
3193: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3562: FROM pa_nl_bill_rate_overrides o

3558: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3559: * p_quantity, o.rate_currency_code)) r_revenue,
3560: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
3561: o.discount_percentage discount_pct
3562: FROM pa_nl_bill_rate_overrides o
3563: WHERE o.task_id = p_task_id
3564: AND o.expenditure_type = p_expenditure_type
3565: AND o.non_labor_resource IS NULL
3566: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3584: FROM pa_nl_bill_rate_overrides o2

3580: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3581: * p_quantity, o2.rate_currency_code)),
3582: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3583: o2.discount_percentage
3584: FROM pa_nl_bill_rate_overrides o2
3585: WHERE o2.project_id = p_project_id
3586: AND o2.expenditure_type = p_expenditure_type
3587: AND o2.non_labor_resource IS NULL
3588: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3595: FROM pa_nl_bill_rate_overrides o3

3591: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3592: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3593: AND NOT EXISTS
3594: (SELECT o3.bill_rate
3595: FROM pa_nl_bill_rate_overrides o3
3596: WHERE o3.task_id = p_task_id
3597: AND o3.expenditure_type = p_expenditure_type
3598: AND o3.non_labor_resource IS NULL
3599: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3617: FROM pa_nl_bill_rate_overrides o

3613: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3614: * p_quantity, o.rate_currency_code)) r_revenue,
3615: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3616: o.discount_percentage discount_pct
3617: FROM pa_nl_bill_rate_overrides o
3618: WHERE o.task_id = p_task_id
3619: AND o.expenditure_type = p_expenditure_type
3620: AND o.non_labor_resource IS NULL
3621: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3638: FROM pa_nl_bill_rate_overrides o2

3634: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3635: * p_quantity, o2.rate_currency_code)),
3636: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3637: o2.discount_percentage
3638: FROM pa_nl_bill_rate_overrides o2
3639: WHERE o2.project_id = p_project_id
3640: AND o2.expenditure_type = p_expenditure_type
3641: AND o2.non_labor_resource IS NULL
3642: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3649: FROM pa_nl_bill_rate_overrides o3

3645: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3646: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3647: AND NOT EXISTS
3648: (SELECT o3.bill_rate
3649: FROM pa_nl_bill_rate_overrides o3
3650: WHERE o3.task_id = p_task_id
3651: AND o3.expenditure_type = p_expenditure_type
3652: AND o3.non_labor_resource IS NULL
3653: AND l_called_process <> 1 /*Added for Doosan rate api change */