APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_ASGN_CURR_S

Line 5207: SELECT pa_resource_asgn_curr_s.nextval

5203: ,TXN_RAW_COST_RATE_OVERRIDE -- 6839167
5204: ,TXN_BURDEN_COST_RATE_OVERRIDE
5205: ,TXN_BILL_RATE_OVERRIDE
5206: )
5207: SELECT pa_resource_asgn_curr_s.nextval
5208: ,l_ra_id_temp_tbl(i)
5209: ,l_curr_code_temp_tbl(i)
5210: ,NULL
5211: ,prac.TXN_RAW_COST_RATE_OVERRIDE --6839167

Line 7341: SELECT pa_resource_asgn_curr_s.nextval

7337: ,RESOURCE_ASSIGNMENT_ID
7338: ,TXN_CURRENCY_CODE
7339: ,DELETE_FLAG
7340: )
7341: SELECT pa_resource_asgn_curr_s.nextval
7342: ,l_resource_assignment_id_tbl(i)
7343: ,l_currency_code_tbl(i)
7344: ,NULL
7345: FROM DUAL;

Line 7917: FROM pa_resource_asgn_curr src_rbc,

7913: src_rbc.txn_currency_code,
7914: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
7915: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
7916: src_rbc.TXN_BILL_RATE_OVERRIDE
7917: FROM pa_resource_asgn_curr src_rbc,
7918: pa_fp_ra_map_tmp map,
7919: --pa_budget_lines bl
7920: pa_resource_assignments ra
7921: WHERE ra.budget_version_id =l_targ_budget_version_id

Line 8367: FROM pa_resource_asgn_curr src_rbc,

8363: src_rbc.txn_currency_code,
8364: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
8365: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
8366: src_rbc.TXN_BILL_RATE_OVERRIDE
8367: FROM pa_resource_asgn_curr src_rbc,
8368: pa_fp_ra_map_tmp map,
8369: --pa_budget_lines bl
8370: pa_resource_assignments ra
8371: WHERE ra.budget_version_id =l_targ_budget_version_id

Line 9037: SELECT pa_resource_asgn_curr_s.nextval

9033: ,RESOURCE_ASSIGNMENT_ID
9034: ,TXN_CURRENCY_CODE
9035: ,DELETE_FLAG
9036: )
9037: SELECT pa_resource_asgn_curr_s.nextval
9038: ,l_resource_assignment_id_tbl(i)
9039: ,l_txn_currency_code_tbl(i)
9040: ,'Y'
9041: FROM DUAL;

Line 9076: SELECT pa_resource_asgn_curr_s.nextval

9072: ,RESOURCE_ASSIGNMENT_ID
9073: -- ,TXN_CURRENCY_CODE
9074: ,DELETE_FLAG
9075: )
9076: SELECT pa_resource_asgn_curr_s.nextval
9077: ,l_ra_id_in_pra_tbl(i)
9078: -- ,l_txn_currency_code_tbl(i)
9079: ,'Y'
9080: FROM DUAL;

Line 9183: SELECT pa_resource_asgn_curr_s.nextval

9179: ,RESOURCE_ASSIGNMENT_ID
9180: -- ,TXN_CURRENCY_CODE
9181: ,DELETE_FLAG
9182: )
9183: SELECT pa_resource_asgn_curr_s.nextval
9184: ,l_resource_assignment_id_tbl(i)
9185: -- ,l_txn_currency_code_tbl(i)
9186: ,'Y'
9187: FROM DUAL;

Line 9221: SELECT pa_resource_asgn_curr_s.nextval

9217: ,RESOURCE_ASSIGNMENT_ID
9218: -- ,TXN_CURRENCY_CODE
9219: ,DELETE_FLAG
9220: )
9221: SELECT pa_resource_asgn_curr_s.nextval
9222: ,l_ra_id_in_pra_tbl(i)
9223: -- ,l_project_currency_code
9224: ,'Y'
9225: FROM DUAL;

Line 9343: SELECT pa_resource_asgn_curr_s.nextval

9339: ,RESOURCE_ASSIGNMENT_ID
9340: -- ,TXN_CURRENCY_CODE
9341: ,DELETE_FLAG
9342: )
9343: SELECT pa_resource_asgn_curr_s.nextval
9344: ,l_resource_assignment_id_tbl(i)
9345: -- ,l_txn_currency_code_tbl(i)
9346: ,'Y'
9347: FROM DUAL;

Line 9392: SELECT pa_resource_asgn_curr_s.nextval

9388: ,RESOURCE_ASSIGNMENT_ID
9389: -- ,TXN_CURRENCY_CODE
9390: ,DELETE_FLAG
9391: )
9392: SELECT pa_resource_asgn_curr_s.nextval
9393: ,l_ra_id_in_pra_tbl(i)
9394: -- ,l_project_currency_code
9395: ,'Y'
9396: FROM DUAL;

Line 9560: SELECT pa_resource_asgn_curr_s.nextval

9556: ,RESOURCE_ASSIGNMENT_ID
9557: ,TXN_CURRENCY_CODE -- Bug 5057010
9558: ,DELETE_FLAG
9559: )
9560: SELECT pa_resource_asgn_curr_s.nextval
9561: ,l_resource_assignment_id_tbl(i)
9562: ,l_txn_currency_code_tbl(i) -- Bug 5057010
9563: ,'Y'
9564: FROM DUAL;

Line 9607: SELECT pa_resource_asgn_curr_s.nextval

9603: ,RESOURCE_ASSIGNMENT_ID
9604: -- ,TXN_CURRENCY_CODE
9605: ,DELETE_FLAG
9606: )
9607: SELECT pa_resource_asgn_curr_s.nextval
9608: ,l_ra_id_in_pra_tbl(i)
9609: -- ,l_project_currency_code
9610: ,'Y'
9611: FROM DUAL;

Line 10922: SELECT pa_resource_asgn_curr_s.NEXTVAL

10918: (RA_TXN_ID
10919: ,RESOURCE_ASSIGNMENT_ID
10920: ,DELETE_FLAG
10921: )
10922: SELECT pa_resource_asgn_curr_s.NEXTVAL
10923: ,l_delete_ra_id_tbl(i)
10924: ,'Y'
10925: FROM DUAL;
10926: END IF;

Line 11045: SELECT pa_resource_asgn_curr_s.NEXTVAL

11041: (RA_TXN_ID
11042: ,RESOURCE_ASSIGNMENT_ID
11043: ,DELETE_FLAG
11044: )
11045: SELECT pa_resource_asgn_curr_s.NEXTVAL
11046: ,l_delete_ra_id_tbl(i)
11047: ,'Y'
11048: FROM DUAL;
11049: END IF;