APPS.CSTPAPBR dependencies on BOM_RESOURCES

Line 8045: from bom_resources

8041: l_stmt_num := 15;
8042:
8043: select nvl(absorption_account,-1)
8044: into l_ae_line_rec.account
8045: from bom_resources
8046: where resource_id = l_res_id
8047: and organization_id = i_ae_txn_rec.xfer_organization_id;
8048: else
8049: l_stmt_num := 20;

Line 8053: from bom_resources

8049: l_stmt_num := 20;
8050:
8051: select nvl(absorption_account,-1)
8052: into l_ae_line_rec.account
8053: from bom_resources
8054: where resource_id = l_res_id
8055: and organization_id = i_ae_txn_rec.organization_id;
8056: end if;
8057:

Line 8953: from bom_resources

8949: -- -----------------------
8950: l_stmt_num := 10;
8951: select count(resource_id)
8952: into l_acct_exist
8953: from bom_resources
8954: where resource_id = i_ae_line_rec.resource_id
8955: and organization_id = i_ae_txn_rec.organization_id
8956: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */
8957:

Line 8965: from bom_resources

8961:
8962: l_stmt_num := 20;
8963: select nvl(absorption_account,-1)
8964: into o_acct_id2
8965: from bom_resources
8966: where resource_id = i_ae_line_rec.resource_id
8967: and organization_id = i_ae_txn_rec.organization_id;
8968:
8969: END IF; -- check for i_ae_txn_rec.txn_type_id <> 6