DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on STANDARD

Line 2409: ,standard_bill_rate

2405: ,resource_assignment_type
2406: ,total_project_raw_cost
2407: ,total_project_burdened_cost
2408: ,total_project_revenue
2409: ,standard_bill_rate
2410: ,average_bill_rate
2411: ,average_cost_rate
2412: ,project_assignment_id
2413: ,plan_error_code

Line 2530: ,standard_bill_rate

2526: ,pra.resource_assignment_type
2527: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
2528: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
2529: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
2530: ,standard_bill_rate
2531: ,average_bill_rate
2532: ,average_cost_rate
2533: ,pfrmt.system_reference3 -- Project assignment id of the target (Bug 3354518)
2534: ,plan_error_code

Line 2689: ,standard_bill_rate

2685: ,resource_assignment_type
2686: ,total_project_raw_cost
2687: ,total_project_burdened_cost
2688: ,total_project_revenue
2689: ,standard_bill_rate
2690: ,average_bill_rate
2691: ,average_cost_rate
2692: ,project_assignment_id
2693: ,plan_error_code

Line 2810: ,standard_bill_rate

2806: ,pra.resource_assignment_type
2807: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
2808: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
2809: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
2810: ,standard_bill_rate
2811: ,average_bill_rate
2812: ,average_cost_rate
2813: ,pfrmt.system_reference3 -- Project assignment id of the target (Bug 3354518)
2814: ,plan_error_code

Line 2956: ,standard_bill_rate

2952: ,resource_assignment_type
2953: ,total_project_raw_cost
2954: ,total_project_burdened_cost
2955: ,total_project_revenue
2956: ,standard_bill_rate
2957: ,average_bill_rate
2958: ,average_cost_rate
2959: ,project_assignment_id
2960: ,plan_error_code

Line 3078: ,standard_bill_rate

3074: ,pra.resource_assignment_type
3075: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3076: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3077: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3078: ,standard_bill_rate
3079: ,average_bill_rate
3080: ,average_cost_rate
3081: ,pra.project_assignment_id
3082: ,plan_error_code

Line 3218: ,standard_bill_rate

3214: ,resource_assignment_type
3215: ,total_project_raw_cost
3216: ,total_project_burdened_cost
3217: ,total_project_revenue
3218: ,standard_bill_rate
3219: ,average_bill_rate
3220: ,average_cost_rate
3221: ,project_assignment_id
3222: ,plan_error_code

Line 3340: ,standard_bill_rate

3336: ,pra.resource_assignment_type
3337: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3338: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3339: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3340: ,standard_bill_rate
3341: ,average_bill_rate
3342: ,average_cost_rate
3343: ,pra.project_assignment_id
3344: ,plan_error_code

Line 3488: ,standard_bill_rate

3484: ,resource_assignment_type
3485: ,total_project_raw_cost
3486: ,total_project_burdened_cost
3487: ,total_project_revenue
3488: ,standard_bill_rate
3489: ,average_bill_rate
3490: ,average_cost_rate
3491: ,project_assignment_id
3492: ,plan_error_code

Line 3610: ,standard_bill_rate

3606: ,pra.resource_assignment_type
3607: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3608: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3609: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3610: ,standard_bill_rate
3611: ,average_bill_rate
3612: ,average_cost_rate
3613: ,pra.project_assignment_id
3614: ,plan_error_code

Line 3763: ,standard_bill_rate

3759: ,resource_assignment_type
3760: ,total_project_raw_cost
3761: ,total_project_burdened_cost
3762: ,total_project_revenue
3763: ,standard_bill_rate
3764: ,average_bill_rate
3765: ,average_cost_rate
3766: ,project_assignment_id
3767: ,plan_error_code

Line 3885: ,standard_bill_rate

3881: ,pra.resource_assignment_type
3882: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3883: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3884: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3885: ,standard_bill_rate
3886: ,average_bill_rate
3887: ,average_cost_rate
3888: ,pra.project_assignment_id
3889: ,plan_error_code

Line 4997: ,txn_standard_bill_rate

4993: ,txn_init_revenue
4994: ,txn_markup_percent
4995: ,txn_markup_percent_override
4996: ,txn_discount_percentage
4997: ,txn_standard_bill_rate
4998: ,txn_standard_cost_rate
4999: ,txn_cost_rate_override
5000: ,burden_cost_rate
5001: ,txn_bill_rate_override

Line 4998: ,txn_standard_cost_rate

4994: ,txn_markup_percent
4995: ,txn_markup_percent_override
4996: ,txn_discount_percentage
4997: ,txn_standard_bill_rate
4998: ,txn_standard_cost_rate
4999: ,txn_cost_rate_override
5000: ,burden_cost_rate
5001: ,txn_bill_rate_override
5002: ,burden_cost_rate_override

Line 5117: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_bill_rate,NULL),NULL) --txn_standard_bill_rate

5113: ,DECODE(l_revenue_flag,'Y',decode(p_copy_actuals_flag,'N',NULL,pbl.txn_init_revenue),NULL) --txn_init_revenue
5114: ,txn_markup_percent
5115: ,txn_markup_percent_override
5116: ,txn_discount_percentage
5117: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_bill_rate,NULL),NULL) --txn_standard_bill_rate
5118: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_cost_rate,NULL),NULL) --txn_standard_cost_rate
5119: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_cost_rate_override,NULL),NULL) --txn_cost_rate_override
5120: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate,NULL),NULL) --burden_cost_rate
5121: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_bill_rate_override,NULL),NULL) --txn_bill_rate_override

Line 5118: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_cost_rate,NULL),NULL) --txn_standard_cost_rate

5114: ,txn_markup_percent
5115: ,txn_markup_percent_override
5116: ,txn_discount_percentage
5117: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_bill_rate,NULL),NULL) --txn_standard_bill_rate
5118: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_cost_rate,NULL),NULL) --txn_standard_cost_rate
5119: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_cost_rate_override,NULL),NULL) --txn_cost_rate_override
5120: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate,NULL),NULL) --burden_cost_rate
5121: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_bill_rate_override,NULL),NULL) --txn_bill_rate_override
5122: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate_override,NULL),NULL) --burden_cost_rate_override

Line 7622: ,txn_standard_cost_rate

7618: ,txn_currency_code
7619: ,txn_revenue
7620: ,bucketing_period_code
7621: -- 3/28/2004 FP M phase II Copy Project Impact
7622: ,txn_standard_cost_rate
7623: ,txn_cost_rate_override
7624: ,cost_ind_compiled_set_id
7625: ,txn_standard_bill_rate
7626: ,txn_bill_rate_override

Line 7625: ,txn_standard_bill_rate

7621: -- 3/28/2004 FP M phase II Copy Project Impact
7622: ,txn_standard_cost_rate
7623: ,txn_cost_rate_override
7624: ,cost_ind_compiled_set_id
7625: ,txn_standard_bill_rate
7626: ,txn_bill_rate_override
7627: ,txn_markup_percent
7628: ,txn_markup_percent_override
7629: ,txn_discount_percentage

Line 7757: ,NULL -- txn_standard_cost_rate

7753: ,txn_currency_code
7754: ,txn_revenue
7755: ,NULL --bucketing_period_code
7756: -- 3/28/2004 FP M phase II Copy Project Impact
7757: ,NULL -- txn_standard_cost_rate
7758: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7759: ,cost_ind_compiled_set_id
7760: ,NULL -- txn_standard_bill_rate
7761: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override

Line 7758: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override

7754: ,txn_revenue
7755: ,NULL --bucketing_period_code
7756: -- 3/28/2004 FP M phase II Copy Project Impact
7757: ,NULL -- txn_standard_cost_rate
7758: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7759: ,cost_ind_compiled_set_id
7760: ,NULL -- txn_standard_bill_rate
7761: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
7762: ,NULL -- txn_markup_percent

Line 7760: ,NULL -- txn_standard_bill_rate

7756: -- 3/28/2004 FP M phase II Copy Project Impact
7757: ,NULL -- txn_standard_cost_rate
7758: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7759: ,cost_ind_compiled_set_id
7760: ,NULL -- txn_standard_bill_rate
7761: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
7762: ,NULL -- txn_markup_percent
7763: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
7764: ,txn_discount_percentage

Line 7761: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override

7757: ,NULL -- txn_standard_cost_rate
7758: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7759: ,cost_ind_compiled_set_id
7760: ,NULL -- txn_standard_bill_rate
7761: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
7762: ,NULL -- txn_markup_percent
7763: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
7764: ,txn_discount_percentage
7765: ,transfer_price_rate

Line 7940: ,txn_standard_cost_rate

7936: ,txn_currency_code
7937: ,txn_revenue
7938: ,bucketing_period_code
7939: -- 3/28/2004 FP M phase II Copy Project Impact
7940: ,txn_standard_cost_rate
7941: ,txn_cost_rate_override
7942: ,cost_ind_compiled_set_id
7943: ,txn_standard_bill_rate
7944: ,txn_bill_rate_override

Line 7943: ,txn_standard_bill_rate

7939: -- 3/28/2004 FP M phase II Copy Project Impact
7940: ,txn_standard_cost_rate
7941: ,txn_cost_rate_override
7942: ,cost_ind_compiled_set_id
7943: ,txn_standard_bill_rate
7944: ,txn_bill_rate_override
7945: ,txn_markup_percent
7946: ,txn_markup_percent_override
7947: ,txn_discount_percentage

Line 8057: ,NULL -- txn_standard_cost_rate

8053: ,txn_burdened_cost
8054: ,txn_currency_code
8055: ,txn_revenue
8056: ,NULL --bucketing_period_code
8057: ,NULL -- txn_standard_cost_rate
8058: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8059: ,cost_ind_compiled_set_id
8060: ,NULL -- txn_standard_bill_rate
8061: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override

Line 8058: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override

8054: ,txn_currency_code
8055: ,txn_revenue
8056: ,NULL --bucketing_period_code
8057: ,NULL -- txn_standard_cost_rate
8058: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8059: ,cost_ind_compiled_set_id
8060: ,NULL -- txn_standard_bill_rate
8061: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
8062: ,NULL -- txn_markup_percent

Line 8060: ,NULL -- txn_standard_bill_rate

8056: ,NULL --bucketing_period_code
8057: ,NULL -- txn_standard_cost_rate
8058: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8059: ,cost_ind_compiled_set_id
8060: ,NULL -- txn_standard_bill_rate
8061: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
8062: ,NULL -- txn_markup_percent
8063: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
8064: ,txn_discount_percentage

Line 8061: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override

8057: ,NULL -- txn_standard_cost_rate
8058: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8059: ,cost_ind_compiled_set_id
8060: ,NULL -- txn_standard_bill_rate
8061: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
8062: ,NULL -- txn_markup_percent
8063: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
8064: ,txn_discount_percentage
8065: ,transfer_price_rate

Line 9831: ,txn_standard_bill_rate

9827: ,txn_init_revenue
9828: ,txn_markup_percent
9829: ,txn_markup_percent_override
9830: ,txn_discount_percentage
9831: ,txn_standard_bill_rate
9832: ,txn_standard_cost_rate
9833: ,txn_cost_rate_override
9834: ,burden_cost_rate
9835: ,txn_bill_rate_override

Line 9832: ,txn_standard_cost_rate

9828: ,txn_markup_percent
9829: ,txn_markup_percent_override
9830: ,txn_discount_percentage
9831: ,txn_standard_bill_rate
9832: ,txn_standard_cost_rate
9833: ,txn_cost_rate_override
9834: ,burden_cost_rate
9835: ,txn_bill_rate_override
9836: ,burden_cost_rate_override

Line 9956: ,null -- txn_standard_bill_rate

9952: ,NULL --txn_init_revenue
9953: ,null -- txn_markup_percent
9954: ,null -- txn_markup_percent_override
9955: ,null -- txn_discount_percentage
9956: ,null -- txn_standard_bill_rate
9957: ,null -- txn_standard_cost_rate
9958: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_cost_rate_override,NULL),NULL) -- txn_cost_rate_override
9959: ,null -- burden_cost_rate
9960: ,DECODE(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_bill_rate_override,NULL),NULL) -- txn_bill_rate_override

Line 9957: ,null -- txn_standard_cost_rate

9953: ,null -- txn_markup_percent
9954: ,null -- txn_markup_percent_override
9955: ,null -- txn_discount_percentage
9956: ,null -- txn_standard_bill_rate
9957: ,null -- txn_standard_cost_rate
9958: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_cost_rate_override,NULL),NULL) -- txn_cost_rate_override
9959: ,null -- burden_cost_rate
9960: ,DECODE(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_bill_rate_override,NULL),NULL) -- txn_bill_rate_override
9961: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_burden_cost_rate_override,NULL),NULL) -- burden_cost_rate_override