APPS.PA_BC_COSTING dependencies on PA_MAPPABLE_TXNS_TMP

Line 960: ,pa_mappable_txns_tmp resmap

956: ,decode(btc_cdl.burden_amt_disp_method,'D','BURDEN','RAW') pkt_line_type
957: --FP M changes
958: ,btc_cdl.dr_code_combination_id dr_ccid
959: FROM pa_res_map_btc_v btc_cdl
960: ,pa_mappable_txns_tmp resmap
961: WHERE btc_cdl.request_id = g_request_id
962: AND resmap.system_reference3 = btc_cdl.request_id
963: AND resmap.system_reference2 = btc_cdl.line_num
964: AND resmap.system_reference1 = btc_cdl.expenditure_item_id

Line 1076: Insert into PA_MAPPABLE_TXNS_TMP

1072: print_msg(l_debug_mode,l_debug_stage);
1073:
1074: If l_resRecCount > 0 Then
1075: FORALL i IN l_resmap_exp_item_id.FIRST .. l_resmap_exp_item_id.LAST
1076: Insert into PA_MAPPABLE_TXNS_TMP
1077: (txn_id,
1078: person_id,
1079: job_id,
1080: organization_id,

Line 1099: pa_mappable_txns_tmp_s.NEXTVAL

1095: system_reference4,
1096: system_reference5
1097: )
1098: SELECT
1099: pa_mappable_txns_tmp_s.NEXTVAL
1100: ,l_resmap_person_id(i)
1101: ,l_resmap_job_id(i)
1102: ,l_resmap_organization_id(i)
1103: ,l_resmap_vendor_id(i)