APPS.CSTPAPBR dependencies on BOM_RESOURCES

Line 7662: from bom_resources

7658: l_stmt_num := 15;
7659:
7660: select nvl(absorption_account,-1)
7661: into l_ae_line_rec.account
7662: from bom_resources
7663: where resource_id = l_res_id
7664: and organization_id = i_ae_txn_rec.xfer_organization_id;
7665: else
7666: l_stmt_num := 20;

Line 7670: from bom_resources

7666: l_stmt_num := 20;
7667:
7668: select nvl(absorption_account,-1)
7669: into l_ae_line_rec.account
7670: from bom_resources
7671: where resource_id = l_res_id
7672: and organization_id = i_ae_txn_rec.organization_id;
7673: end if;
7674:

Line 8512: from bom_resources

8508: -- -----------------------
8509: l_stmt_num := 10;
8510: select count(resource_id)
8511: into l_acct_exist
8512: from bom_resources
8513: where resource_id = i_ae_line_rec.resource_id
8514: and organization_id = i_ae_txn_rec.organization_id
8515: and rownum < 2; /* 4586534 added rownum filter for perf as its only existence check */
8516:

Line 8524: from bom_resources

8520:
8521: l_stmt_num := 20;
8522: select nvl(absorption_account,-1)
8523: into o_acct_id2
8524: from bom_resources
8525: where resource_id = i_ae_line_rec.resource_id
8526: and organization_id = i_ae_txn_rec.organization_id;
8527:
8528: END IF; -- check for i_ae_txn_rec.txn_type_id <> 6