[Home] [Help]
8374: FROM zx_lines zx,
8375: zx_lines_det_factors zxdet
8376: WHERE zx.trx_line_id = cp_trx_line_id
8377: AND zx.trx_id = cp_trx_id
8378: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8379: AND zx.entity_code = G_AR_ENTITY_CODE
8380: AND zx.event_class_code = G_INVOICE_EVENT_CLASS_CODE
8381: AND zx.application_id = G_AR_APPLICATION_ID
8382: AND zx.trx_line_id = zxdet.trx_line_id
8437: FROM zx_lines zx,
8438: zx_lines_det_factors zxdet
8439: WHERE zx.trx_id = cp_trx_id
8440: AND zx.trx_line_id = cp_trx_line_id
8441: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8442: AND zx.entity_code = G_AR_ENTITY_CODE
8443: AND zx.event_class_code = G_INVOICE_EVENT_CLASS_CODE
8444: AND zx.application_id = G_AR_APPLICATION_ID
8445: AND zx.trx_line_id = zxdet.trx_line_id
9999: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
10000: SELECT fma_id
10001: FROM okl_tax_basis_override
10002: WHERE try_id = cp_try_id
10003: AND org_id = MO_GLOBAL.get_current_org_id;
10004:
10005: -- GET FORMULA NAME
10006: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
10007: SELECT name
10985: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
10986: SELECT fma_id
10987: FROM okl_tax_basis_override
10988: WHERE try_id = cp_try_id
10989: AND org_id = MO_GLOBAL.get_current_org_id;
10990:
10991: -- get the inventory item id and inventory item org for a financial asset
10992: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
10993: SELECT cim_model.object1_id1,
11053: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
11054: AND b.site_use_code = 'SHIP_TO'
11055: AND a.party_site_id = c.party_site_id
11056: AND a.cust_account_id = cp_cust_acct_id
11057: AND a.org_id = MO_GLOBAL.get_current_org_id
11058: AND c.party_site_id = cp_inst_loc_id
11059: AND c.location_id = cp_loc_id;
11060:
11061: SUBTYPE txsv_rec_type IS okl_txs_pvt.txsv_rec_type;
13292: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
13293: SELECT fma_id
13294: FROM okl_tax_basis_override
13295: WHERE try_id = cp_try_id
13296: AND org_id = MO_GLOBAL.get_current_org_id;
13297:
13298: -- GET FORMULA NAME
13299: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
13300: SELECT name
15804: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
15805: SELECT fma_id
15806: FROM okl_tax_basis_override
15807: WHERE try_id = cp_try_id
15808: AND org_id = MO_GLOBAL.get_current_org_id;
15809:
15810: -- GET FORMULA NAME
15811: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
15812: SELECT name
15852: WHERE a.cust_acct_site_id = b.cust_acct_site_id
15853: AND b.site_use_code = 'SHIP_TO'
15854: AND a.party_site_id = c.party_site_id
15855: AND a.cust_account_id = cp_cust_acct_id
15856: AND a.org_id = MO_GLOBAL.get_current_org_id
15857: AND c.party_site_id = cp_inst_loc_id
15858: AND c.location_id = cp_loc_id;
15859:
15860: TYPE asset_level_det_rec_type IS RECORD
17560: RAISE OKL_API.G_EXCEPTION_ERROR;
17561: END IF;
17562:
17563: l_source_table := upper(p_source_table);
17564: l_org_id := mo_global.get_current_org_id;
17565:
17566: -- Get the OU Tax options
17567: OPEN l_systemparams_csr(cp_org_id => l_org_id);
17568: FETCH l_systemparams_csr INTO l_ou_tax_upfront_yn, l_ou_tax_invoice_yn;
19001: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
19002: SELECT fma_id
19003: FROM okl_tax_basis_override
19004: WHERE try_id = cp_try_id
19005: AND org_id = MO_GLOBAL.get_current_org_id;
19006:
19007: -- get formula name
19008: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
19009: SELECT name