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 2983: FROM pa_nl_bill_rate_overrides o

2979: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
2980: * p_quantity , o.rate_currency_code)) r_revenue,
2981: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
2982: o.discount_percentage discount_pct
2983: FROM pa_nl_bill_rate_overrides o
2984: WHERE o.task_id = p_task_id
2985: AND o.expenditure_type = p_expenditure_type
2986: AND o.non_labor_resource = p_non_labor_resource
2987: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3004: FROM pa_nl_bill_rate_overrides o

3000: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3001: * p_quantity, o.rate_currency_code)),
3002: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
3003: o.discount_percentage discount_pct
3004: FROM pa_nl_bill_rate_overrides o
3005: WHERE o.task_id = p_task_id
3006: AND o.expenditure_type = p_expenditure_type
3007: AND o.non_labor_resource is NULL
3008: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3015: FROM pa_nl_bill_rate_overrides o3

3011: BETWEEN trunc(o.start_date_active) /* BUG#3118592 */
3012: AND trunc(NVL(o.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3013: AND NOT EXISTS
3014: (SELECT o3.bill_rate
3015: FROM pa_nl_bill_rate_overrides o3
3016: WHERE o3.task_id = p_task_id
3017: AND o3.expenditure_type = p_expenditure_type
3018: AND o3.non_labor_resource = p_non_labor_resource
3019: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3037: FROM pa_nl_bill_rate_overrides o2

3033: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3034: * p_quantity, o2.rate_currency_code)),
3035: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3036: o2.discount_percentage discount_pct
3037: FROM pa_nl_bill_rate_overrides o2
3038: WHERE o2.project_id = p_project_id
3039: AND o2.expenditure_type = p_expenditure_type
3040: AND o2.non_labor_resource = p_non_labor_resource
3041: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3048: FROM pa_nl_bill_rate_overrides o3

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

Line 3069: FROM pa_nl_bill_rate_overrides o2

3065: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3066: * p_quantity, o2.rate_currency_code)) r_revenue,
3067: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3068: o2.discount_percentage discount_pct
3069: FROM pa_nl_bill_rate_overrides o2
3070: WHERE o2.project_id = p_project_id
3071: AND o2.expenditure_type = p_expenditure_type
3072: AND o2.non_labor_resource is NULL
3073: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3080: FROM pa_nl_bill_rate_overrides o3

3076: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3077: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3078: AND NOT EXISTS
3079: (SELECT o3.bill_rate
3080: FROM pa_nl_bill_rate_overrides o3
3081: WHERE o3.task_id = p_task_id
3082: AND o3.expenditure_type = p_expenditure_type
3083: AND l_called_process <> 1 /*Added for Doosan rate api change */
3084: AND (o3.bill_rate IS NULL OR p_uom_flag =1 ) /*Added for UOM enhancement */

Line 3090: FROM pa_nl_bill_rate_overrides o3

3086: BETWEEN trunc(o3.start_date_active) /* BUG#3118592 */
3087: AND trunc(NVL(o3.end_date_active,p_expenditure_item_date))) /* BUG#3118592 */
3088: AND NOT EXISTS
3089: (SELECT o3.bill_rate
3090: FROM pa_nl_bill_rate_overrides o3
3091: WHERE o3.project_id = p_project_id
3092: AND o3.expenditure_type = p_expenditure_type
3093: AND o3.non_labor_resource = p_non_labor_resource
3094: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3113: FROM pa_nl_bill_rate_overrides o

3109: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3110: * p_quantity, o.rate_currency_code)) r_revenue,
3111: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3112: o.discount_percentage discount_pct
3113: FROM pa_nl_bill_rate_overrides o
3114: WHERE o.task_id = p_task_id
3115: AND o.expenditure_type = p_expenditure_type
3116: AND o.non_labor_resource = p_non_labor_resource
3117: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3132: FROM pa_nl_bill_rate_overrides o

3128: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3129: * p_quantity, o.rate_currency_code)),
3130: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code ,
3131: o.discount_percentage discount_pct
3132: FROM pa_nl_bill_rate_overrides o
3133: WHERE o.task_id = p_task_id
3134: AND o.expenditure_type = p_expenditure_type
3135: AND o.non_labor_resource is NULL
3136: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3143: FROM pa_nl_bill_rate_overrides o3

3139: BETWEEN trunc(o.start_date_active) /* BUG#3118592 */
3140: AND trunc(NVL(o.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3141: AND NOT EXISTS
3142: (SELECT o3.bill_rate
3143: FROM pa_nl_bill_rate_overrides o3
3144: WHERE o3.task_id = p_task_id
3145: AND o3.expenditure_type = p_expenditure_type
3146: AND o3.non_labor_resource = p_non_labor_resource
3147: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3163: FROM pa_nl_bill_rate_overrides o2

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

Line 3174: FROM pa_nl_bill_rate_overrides o3

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

Line 3193: FROM pa_nl_bill_rate_overrides o2

3189: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3190: * p_quantity, o2.rate_currency_code)),
3191: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3192: o2.discount_percentage discount_pct
3193: FROM pa_nl_bill_rate_overrides o2
3194: WHERE o2.project_id = p_project_id
3195: AND o2.expenditure_type = p_expenditure_type
3196: AND o2.non_labor_resource is NULL
3197: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3204: FROM pa_nl_bill_rate_overrides o3

3200: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3201: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3202: AND NOT EXISTS
3203: (SELECT o3.bill_rate
3204: FROM pa_nl_bill_rate_overrides o3
3205: WHERE o3.task_id = p_task_id
3206: AND o3.expenditure_type = p_expenditure_type
3207: AND l_called_process <> 1 /*Added for Doosan rate api change */
3208: AND (o3.bill_rate IS NULL OR p_uom_flag =1 ) /*Added for UOM enhancement */

Line 3215: FROM pa_nl_bill_rate_overrides o3

3211: AND trunc(NVL(o3.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3212: )
3213: AND NOT EXISTS
3214: (SELECT o3.bill_rate
3215: FROM pa_nl_bill_rate_overrides o3
3216: WHERE o3.project_id = p_project_id
3217: AND o3.expenditure_type = p_expenditure_type
3218: AND o3.non_labor_resource = p_non_labor_resource
3219: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3588: FROM pa_nl_bill_rate_overrides o

3584: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3585: * p_quantity, o.rate_currency_code)) r_revenue,
3586: DECODE(o.bill_rate, NULL, l_mcb_currency_code, o.rate_currency_code) rate_currency_code,
3587: o.discount_percentage discount_pct
3588: FROM pa_nl_bill_rate_overrides o
3589: WHERE o.task_id = p_task_id
3590: AND o.expenditure_type = p_expenditure_type
3591: AND o.non_labor_resource IS NULL
3592: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3610: FROM pa_nl_bill_rate_overrides o2

3606: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3607: * p_quantity, o2.rate_currency_code)),
3608: DECODE(o2.bill_rate, NULL, l_mcb_currency_code, o2.rate_currency_code) rate_currency_code,
3609: o2.discount_percentage
3610: FROM pa_nl_bill_rate_overrides o2
3611: WHERE o2.project_id = p_project_id
3612: AND o2.expenditure_type = p_expenditure_type
3613: AND o2.non_labor_resource IS NULL
3614: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3621: FROM pa_nl_bill_rate_overrides o3

3617: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3618: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3619: AND NOT EXISTS
3620: (SELECT o3.bill_rate
3621: FROM pa_nl_bill_rate_overrides o3
3622: WHERE o3.task_id = p_task_id
3623: AND o3.expenditure_type = p_expenditure_type
3624: AND o3.non_labor_resource IS NULL
3625: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3643: FROM pa_nl_bill_rate_overrides o

3639: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o.bill_rate * NVL(p_bill_rate_multiplier,1)
3640: * p_quantity, o.rate_currency_code)) r_revenue,
3641: DECODE(o.bill_rate, NULL, p_proj_func_currency, o.rate_currency_code) rate_currency_code,
3642: o.discount_percentage discount_pct
3643: FROM pa_nl_bill_rate_overrides o
3644: WHERE o.task_id = p_task_id
3645: AND o.expenditure_type = p_expenditure_type
3646: AND o.non_labor_resource IS NULL
3647: AND l_called_process <> 1 /*Added for Doosan rate api change */

Line 3664: FROM pa_nl_bill_rate_overrides o2

3660: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(o2.bill_rate * NVL(p_bill_rate_multiplier,1)
3661: * p_quantity, o2.rate_currency_code)),
3662: DECODE(o2.bill_rate, NULL, p_proj_func_currency, o2.rate_currency_code) rate_currency_code,
3663: o2.discount_percentage
3664: FROM pa_nl_bill_rate_overrides o2
3665: WHERE o2.project_id = p_project_id
3666: AND o2.expenditure_type = p_expenditure_type
3667: AND o2.non_labor_resource IS NULL
3668: AND l_called_process <> 2 /*Added for Doosan rate api change */

Line 3675: FROM pa_nl_bill_rate_overrides o3

3671: BETWEEN trunc(o2.start_date_active) /* BUG#3118592 */
3672: AND trunc(NVL(o2.end_date_active,p_expenditure_item_date)) /* BUG#3118592 */
3673: AND NOT EXISTS
3674: (SELECT o3.bill_rate
3675: FROM pa_nl_bill_rate_overrides o3
3676: WHERE o3.task_id = p_task_id
3677: AND o3.expenditure_type = p_expenditure_type
3678: AND o3.non_labor_resource IS NULL
3679: AND l_called_process <> 1 /*Added for Doosan rate api change */