APPS.PA_BC_COSTING dependencies on PA_RES_MAP_BTC_V

Line 959: FROM pa_res_map_btc_v btc_cdl

955: ,btc_cdl.system_reference2 po_header_id
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

Line 971: FROM pa_res_map_btc_v btc_rl

967: ,btc_cdl.budget_version_id;
968:
969: CURSOR reslist_cur IS
970: SELECT distinct btc_rl.resource_list_id
971: FROM pa_res_map_btc_v btc_rl
972: WHERE btc_rl.request_id = g_request_id;
973:
974: CURSOR btc_resList_cur
975: IS

Line 996: FROM pa_res_map_btc_v btc_cdl

992: ,btc_cdl.budget_version_id budget_version_id
993: ,btc_cdl.resource_list_id resource_list_id
994: ,btc_cdl.entry_level_code entry_level_code
995: ,g_request_id request_id
996: FROM pa_res_map_btc_v btc_cdl
997: WHERE btc_cdl.request_id = g_request_id
998: ORDER BY NVL(btc_cdl.resource_list_id,0)
999: ,btc_cdl.project_id
1000: ,btc_cdl.budget_version_id