APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_ASGN_CURR_S

Line 5861: SELECT pa_resource_asgn_curr_s.nextval

5857: ,TXN_BURDEN_COST_RATE_OVERRIDE
5858: ,TXN_BILL_RATE_OVERRIDE
5859: ,expenditure_type --added for EnC
5860: )
5861: SELECT pa_resource_asgn_curr_s.nextval
5862: ,l_ra_id_temp_tbl(i)
5863: ,l_curr_code_temp_tbl(i)
5864: ,NULL
5865: ,prac.TXN_RAW_COST_RATE_OVERRIDE --6839167

Line 8167: SELECT pa_resource_asgn_curr_s.nextval

8163: ,RESOURCE_ASSIGNMENT_ID
8164: ,TXN_CURRENCY_CODE
8165: ,DELETE_FLAG
8166: )
8167: SELECT pa_resource_asgn_curr_s.nextval
8168: ,l_resource_assignment_id_tbl(i)
8169: ,l_currency_code_tbl(i)
8170: ,NULL
8171: FROM DUAL;

Line 8743: FROM pa_resource_asgn_curr src_rbc,

8739: src_rbc.txn_currency_code,
8740: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
8741: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
8742: src_rbc.TXN_BILL_RATE_OVERRIDE
8743: FROM pa_resource_asgn_curr src_rbc,
8744: pa_fp_ra_map_tmp map,
8745: --pa_budget_lines bl
8746: pa_resource_assignments ra
8747: WHERE ra.budget_version_id =l_targ_budget_version_id

Line 9193: FROM pa_resource_asgn_curr src_rbc,

9189: src_rbc.txn_currency_code,
9190: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
9191: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
9192: src_rbc.TXN_BILL_RATE_OVERRIDE
9193: FROM pa_resource_asgn_curr src_rbc,
9194: pa_fp_ra_map_tmp map,
9195: --pa_budget_lines bl
9196: pa_resource_assignments ra
9197: WHERE ra.budget_version_id =l_targ_budget_version_id

Line 9869: SELECT pa_resource_asgn_curr_s.nextval

9865: ,RESOURCE_ASSIGNMENT_ID
9866: ,TXN_CURRENCY_CODE
9867: ,DELETE_FLAG
9868: )
9869: SELECT pa_resource_asgn_curr_s.nextval
9870: ,l_resource_assignment_id_tbl(i)
9871: ,l_txn_currency_code_tbl(i)
9872: ,'Y'
9873: FROM DUAL;

Line 9915: SELECT pa_resource_asgn_curr_s.nextval

9911: ,RESOURCE_ASSIGNMENT_ID
9912: -- ,TXN_CURRENCY_CODE
9913: ,DELETE_FLAG
9914: )
9915: SELECT pa_resource_asgn_curr_s.nextval
9916: ,l_ra_id_in_pra_tbl(i)
9917: -- ,l_txn_currency_code_tbl(i)
9918: ,'Y'
9919: FROM DUAL;

Line 10022: SELECT pa_resource_asgn_curr_s.nextval

10018: ,RESOURCE_ASSIGNMENT_ID
10019: -- ,TXN_CURRENCY_CODE
10020: ,DELETE_FLAG
10021: )
10022: SELECT pa_resource_asgn_curr_s.nextval
10023: ,l_resource_assignment_id_tbl(i)
10024: -- ,l_txn_currency_code_tbl(i)
10025: ,'Y'
10026: FROM DUAL;

Line 10067: SELECT pa_resource_asgn_curr_s.nextval

10063: ,RESOURCE_ASSIGNMENT_ID
10064: -- ,TXN_CURRENCY_CODE
10065: ,DELETE_FLAG
10066: )
10067: SELECT pa_resource_asgn_curr_s.nextval
10068: ,l_ra_id_in_pra_tbl(i)
10069: -- ,l_project_currency_code
10070: ,'Y'
10071: FROM DUAL;

Line 10189: SELECT pa_resource_asgn_curr_s.nextval

10185: ,RESOURCE_ASSIGNMENT_ID
10186: -- ,TXN_CURRENCY_CODE
10187: ,DELETE_FLAG
10188: )
10189: SELECT pa_resource_asgn_curr_s.nextval
10190: ,l_resource_assignment_id_tbl(i)
10191: -- ,l_txn_currency_code_tbl(i)
10192: ,'Y'
10193: FROM DUAL;

Line 10246: SELECT pa_resource_asgn_curr_s.nextval

10242: ,RESOURCE_ASSIGNMENT_ID
10243: -- ,TXN_CURRENCY_CODE
10244: ,DELETE_FLAG
10245: )
10246: SELECT pa_resource_asgn_curr_s.nextval
10247: ,l_ra_id_in_pra_tbl(i)
10248: -- ,l_project_currency_code
10249: ,'Y'
10250: FROM DUAL;

Line 10414: SELECT pa_resource_asgn_curr_s.nextval

10410: ,RESOURCE_ASSIGNMENT_ID
10411: ,TXN_CURRENCY_CODE -- Bug 5057010
10412: ,DELETE_FLAG
10413: )
10414: SELECT pa_resource_asgn_curr_s.nextval
10415: ,l_resource_assignment_id_tbl(i)
10416: ,l_txn_currency_code_tbl(i) -- Bug 5057010
10417: ,'Y'
10418: FROM DUAL;

Line 10469: SELECT pa_resource_asgn_curr_s.nextval

10465: ,RESOURCE_ASSIGNMENT_ID
10466: -- ,TXN_CURRENCY_CODE
10467: ,DELETE_FLAG
10468: )
10469: SELECT pa_resource_asgn_curr_s.nextval
10470: ,l_ra_id_in_pra_tbl(i)
10471: -- ,l_project_currency_code
10472: ,'Y'
10473: FROM DUAL;

Line 11789: SELECT pa_resource_asgn_curr_s.NEXTVAL

11785: (RA_TXN_ID
11786: ,RESOURCE_ASSIGNMENT_ID
11787: ,DELETE_FLAG
11788: )
11789: SELECT pa_resource_asgn_curr_s.NEXTVAL
11790: ,l_delete_ra_id_tbl(i)
11791: ,'Y'
11792: FROM DUAL;
11793: END IF;

Line 11919: SELECT pa_resource_asgn_curr_s.NEXTVAL

11915: (RA_TXN_ID
11916: ,RESOURCE_ASSIGNMENT_ID
11917: ,DELETE_FLAG
11918: )
11919: SELECT pa_resource_asgn_curr_s.NEXTVAL
11920: ,l_delete_ra_id_tbl(i)
11921: ,'Y'
11922: FROM DUAL;
11923: END IF;