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 2529: ,standard_bill_rate

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

Line 2687: ,standard_bill_rate

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

Line 2807: ,standard_bill_rate

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

Line 2952: ,standard_bill_rate

2948: ,resource_assignment_type
2949: ,total_project_raw_cost
2950: ,total_project_burdened_cost
2951: ,total_project_revenue
2952: ,standard_bill_rate
2953: ,average_bill_rate
2954: ,average_cost_rate
2955: ,project_assignment_id
2956: ,plan_error_code

Line 3073: ,standard_bill_rate

3069: ,pra.resource_assignment_type
3070: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3071: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3072: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3073: ,standard_bill_rate
3074: ,average_bill_rate
3075: ,average_cost_rate
3076: ,pra.project_assignment_id
3077: ,plan_error_code

Line 3212: ,standard_bill_rate

3208: ,resource_assignment_type
3209: ,total_project_raw_cost
3210: ,total_project_burdened_cost
3211: ,total_project_revenue
3212: ,standard_bill_rate
3213: ,average_bill_rate
3214: ,average_cost_rate
3215: ,project_assignment_id
3216: ,plan_error_code

Line 3333: ,standard_bill_rate

3329: ,pra.resource_assignment_type
3330: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3331: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3332: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3333: ,standard_bill_rate
3334: ,average_bill_rate
3335: ,average_cost_rate
3336: ,pra.project_assignment_id
3337: ,plan_error_code

Line 3480: ,standard_bill_rate

3476: ,resource_assignment_type
3477: ,total_project_raw_cost
3478: ,total_project_burdened_cost
3479: ,total_project_revenue
3480: ,standard_bill_rate
3481: ,average_bill_rate
3482: ,average_cost_rate
3483: ,project_assignment_id
3484: ,plan_error_code

Line 3601: ,standard_bill_rate

3597: ,pra.resource_assignment_type
3598: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3599: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3600: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3601: ,standard_bill_rate
3602: ,average_bill_rate
3603: ,average_cost_rate
3604: ,pra.project_assignment_id
3605: ,plan_error_code

Line 3753: ,standard_bill_rate

3749: ,resource_assignment_type
3750: ,total_project_raw_cost
3751: ,total_project_burdened_cost
3752: ,total_project_revenue
3753: ,standard_bill_rate
3754: ,average_bill_rate
3755: ,average_cost_rate
3756: ,project_assignment_id
3757: ,plan_error_code

Line 3874: ,standard_bill_rate

3870: ,pra.resource_assignment_type
3871: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_raw_cost,NULL),NULL)
3872: ,DECODE(l_adj_percentage,0,DECODE(l_cost_flag,'Y',total_project_burdened_cost,NULL),NULL)
3873: ,DECODE(l_adj_percentage,0,DECODE(l_revenue_flag,'Y',total_project_revenue,NULL),NULL)
3874: ,standard_bill_rate
3875: ,average_bill_rate
3876: ,average_cost_rate
3877: ,pra.project_assignment_id
3878: ,plan_error_code

Line 4985: ,txn_standard_bill_rate

4981: ,txn_init_revenue
4982: ,txn_markup_percent
4983: ,txn_markup_percent_override
4984: ,txn_discount_percentage
4985: ,txn_standard_bill_rate
4986: ,txn_standard_cost_rate
4987: ,txn_cost_rate_override
4988: ,burden_cost_rate
4989: ,txn_bill_rate_override

Line 4986: ,txn_standard_cost_rate

4982: ,txn_markup_percent
4983: ,txn_markup_percent_override
4984: ,txn_discount_percentage
4985: ,txn_standard_bill_rate
4986: ,txn_standard_cost_rate
4987: ,txn_cost_rate_override
4988: ,burden_cost_rate
4989: ,txn_bill_rate_override
4990: ,burden_cost_rate_override

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

5101: ,DECODE(l_revenue_flag,'Y',decode(p_copy_actuals_flag,'N',NULL,pbl.txn_init_revenue),NULL) --txn_init_revenue
5102: ,txn_markup_percent
5103: ,txn_markup_percent_override
5104: ,txn_discount_percentage
5105: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_bill_rate,NULL),NULL) --txn_standard_bill_rate
5106: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_cost_rate,NULL),NULL) --txn_standard_cost_rate
5107: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_cost_rate_override,NULL),NULL) --txn_cost_rate_override
5108: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate,NULL),NULL) --burden_cost_rate
5109: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_bill_rate_override,NULL),NULL) --txn_bill_rate_override

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

5102: ,txn_markup_percent
5103: ,txn_markup_percent_override
5104: ,txn_discount_percentage
5105: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_bill_rate,NULL),NULL) --txn_standard_bill_rate
5106: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_standard_cost_rate,NULL),NULL) --txn_standard_cost_rate
5107: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_cost_rate_override,NULL),NULL) --txn_cost_rate_override
5108: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate,NULL),NULL) --burden_cost_rate
5109: ,Decode(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',txn_bill_rate_override,NULL),NULL) --txn_bill_rate_override
5110: ,Decode(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',burden_cost_rate_override,NULL),NULL) --burden_cost_rate_override

Line 7603: ,txn_standard_cost_rate

7599: ,txn_currency_code
7600: ,txn_revenue
7601: ,bucketing_period_code
7602: -- 3/28/2004 FP M phase II Copy Project Impact
7603: ,txn_standard_cost_rate
7604: ,txn_cost_rate_override
7605: ,cost_ind_compiled_set_id
7606: ,txn_standard_bill_rate
7607: ,txn_bill_rate_override

Line 7606: ,txn_standard_bill_rate

7602: -- 3/28/2004 FP M phase II Copy Project Impact
7603: ,txn_standard_cost_rate
7604: ,txn_cost_rate_override
7605: ,cost_ind_compiled_set_id
7606: ,txn_standard_bill_rate
7607: ,txn_bill_rate_override
7608: ,txn_markup_percent
7609: ,txn_markup_percent_override
7610: ,txn_discount_percentage

Line 7738: ,NULL -- txn_standard_cost_rate

7734: ,txn_currency_code
7735: ,txn_revenue
7736: ,NULL --bucketing_period_code
7737: -- 3/28/2004 FP M phase II Copy Project Impact
7738: ,NULL -- txn_standard_cost_rate
7739: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7740: ,cost_ind_compiled_set_id
7741: ,NULL -- txn_standard_bill_rate
7742: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override

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

7735: ,txn_revenue
7736: ,NULL --bucketing_period_code
7737: -- 3/28/2004 FP M phase II Copy Project Impact
7738: ,NULL -- txn_standard_cost_rate
7739: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7740: ,cost_ind_compiled_set_id
7741: ,NULL -- txn_standard_bill_rate
7742: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
7743: ,NULL -- txn_markup_percent

Line 7741: ,NULL -- txn_standard_bill_rate

7737: -- 3/28/2004 FP M phase II Copy Project Impact
7738: ,NULL -- txn_standard_cost_rate
7739: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7740: ,cost_ind_compiled_set_id
7741: ,NULL -- txn_standard_bill_rate
7742: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
7743: ,NULL -- txn_markup_percent
7744: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
7745: ,txn_discount_percentage

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

7738: ,NULL -- txn_standard_cost_rate
7739: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
7740: ,cost_ind_compiled_set_id
7741: ,NULL -- txn_standard_bill_rate
7742: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
7743: ,NULL -- txn_markup_percent
7744: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
7745: ,txn_discount_percentage
7746: ,transfer_price_rate

Line 7913: ,txn_standard_cost_rate

7909: ,txn_currency_code
7910: ,txn_revenue
7911: ,bucketing_period_code
7912: -- 3/28/2004 FP M phase II Copy Project Impact
7913: ,txn_standard_cost_rate
7914: ,txn_cost_rate_override
7915: ,cost_ind_compiled_set_id
7916: ,txn_standard_bill_rate
7917: ,txn_bill_rate_override

Line 7916: ,txn_standard_bill_rate

7912: -- 3/28/2004 FP M phase II Copy Project Impact
7913: ,txn_standard_cost_rate
7914: ,txn_cost_rate_override
7915: ,cost_ind_compiled_set_id
7916: ,txn_standard_bill_rate
7917: ,txn_bill_rate_override
7918: ,txn_markup_percent
7919: ,txn_markup_percent_override
7920: ,txn_discount_percentage

Line 8030: ,NULL -- txn_standard_cost_rate

8026: ,txn_burdened_cost
8027: ,txn_currency_code
8028: ,txn_revenue
8029: ,NULL --bucketing_period_code
8030: ,NULL -- txn_standard_cost_rate
8031: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8032: ,cost_ind_compiled_set_id
8033: ,NULL -- txn_standard_bill_rate
8034: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override

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

8027: ,txn_currency_code
8028: ,txn_revenue
8029: ,NULL --bucketing_period_code
8030: ,NULL -- txn_standard_cost_rate
8031: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8032: ,cost_ind_compiled_set_id
8033: ,NULL -- txn_standard_bill_rate
8034: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
8035: ,NULL -- txn_markup_percent

Line 8033: ,NULL -- txn_standard_bill_rate

8029: ,NULL --bucketing_period_code
8030: ,NULL -- txn_standard_cost_rate
8031: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8032: ,cost_ind_compiled_set_id
8033: ,NULL -- txn_standard_bill_rate
8034: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
8035: ,NULL -- txn_markup_percent
8036: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
8037: ,txn_discount_percentage

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

8030: ,NULL -- txn_standard_cost_rate
8031: ,nvl(txn_cost_rate_override,txn_standard_cost_rate) -- txn_cost_rate_override
8032: ,cost_ind_compiled_set_id
8033: ,NULL -- txn_standard_bill_rate
8034: ,nvl(txn_bill_rate_override,txn_standard_bill_rate) -- txn_bill_rate_override
8035: ,NULL -- txn_markup_percent
8036: ,nvl(txn_markup_percent_override,txn_markup_percent)-- txn_markup_percent_override
8037: ,txn_discount_percentage
8038: ,transfer_price_rate

Line 9804: ,txn_standard_bill_rate

9800: ,txn_init_revenue
9801: ,txn_markup_percent
9802: ,txn_markup_percent_override
9803: ,txn_discount_percentage
9804: ,txn_standard_bill_rate
9805: ,txn_standard_cost_rate
9806: ,txn_cost_rate_override
9807: ,burden_cost_rate
9808: ,txn_bill_rate_override

Line 9805: ,txn_standard_cost_rate

9801: ,txn_markup_percent
9802: ,txn_markup_percent_override
9803: ,txn_discount_percentage
9804: ,txn_standard_bill_rate
9805: ,txn_standard_cost_rate
9806: ,txn_cost_rate_override
9807: ,burden_cost_rate
9808: ,txn_bill_rate_override
9809: ,burden_cost_rate_override

Line 9929: ,null -- txn_standard_bill_rate

9925: ,NULL --txn_init_revenue
9926: ,null -- txn_markup_percent
9927: ,null -- txn_markup_percent_override
9928: ,null -- txn_discount_percentage
9929: ,null -- txn_standard_bill_rate
9930: ,null -- txn_standard_cost_rate
9931: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_cost_rate_override,NULL),NULL) -- txn_cost_rate_override
9932: ,null -- burden_cost_rate
9933: ,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 9930: ,null -- txn_standard_cost_rate

9926: ,null -- txn_markup_percent
9927: ,null -- txn_markup_percent_override
9928: ,null -- txn_discount_percentage
9929: ,null -- txn_standard_bill_rate
9930: ,null -- txn_standard_cost_rate
9931: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_cost_rate_override,NULL),NULL) -- txn_cost_rate_override
9932: ,null -- burden_cost_rate
9933: ,DECODE(l_revenue_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_txn_bill_rate_override,NULL),NULL) -- txn_bill_rate_override
9934: ,DECODE(l_cost_flag,'Y',DECODE(p_derv_rates_missing_amts_flag,'N',l_burden_cost_rate_override,NULL),NULL) -- burden_cost_rate_override