APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 1200: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

1196: -- to be calculated for each line.
1197: BEGIN
1198: SELECT INV_TYPE.TAX_CALCULATION_FLAG
1199: INTO l_tax_calculation_flag
1200: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
1201: WHERE INV_TYPE.CUST_TRX_TYPE_ID = zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(l_index)
1202: AND ORG_ID = zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(l_index);
1203: EXCEPTION
1204: WHEN OTHERS THEN

Line 1817: from ra_cust_trx_types_all

1813:
1814: /* BugFix 2057800: add this cursor to check the trx type.*/
1815: CURSOR c_chk_trx_type (c_trx_type_id IN NUMBER) IS
1816: select type
1817: from ra_cust_trx_types_all
1818: where cust_trx_type_id = c_trx_type_id
1819: and org_id = sysinfo.sysparam.org_id;
1820:
1821: l_tax_info_rec tax_info_rec_type;

Line 2194: from ra_cust_trx_types_all

2190:
2191: /* BugFix 2057800: add this cursor to check the trx type.*/
2192: CURSOR c_chk_trx_type (c_trx_type_id IN NUMBER) IS
2193: select type
2194: from ra_cust_trx_types_all
2195: where cust_trx_type_id = c_trx_type_id
2196: and org_id = sysinfo.sysparam.org_id;
2197:
2198:

Line 2201: from ra_cust_trx_types_all ct

2197:
2198:
2199: cursor calculation_flag_csr(c_cust_trx_type_id in number) is
2200: select tax_calculation_flag
2201: from ra_cust_trx_types_all ct
2202: where ct.cust_trx_type_id = c_cust_trx_type_id
2203: and org_id = sysinfo.sysparam.org_id;
2204:
2205: BEGIN

Line 2417: ra_cust_trx_types_all trx_type,

2413:
2414: select inv_trx.trx_date
2415: into l_inv_trx_date
2416: from ra_customer_trx_all inv_trx,
2417: ra_cust_trx_types_all trx_type,
2418: ra_customer_trx_all trx
2419: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2420: and trx_type.type = 'CM'
2421: and trx_type.org_id = trx.org_id

Line 2430: ra_cust_trx_types_all trx_type,

2426:
2427: select inv_trx.trx_date
2428: into l_inv_trx_date
2429: from ra_customer_trx_all inv_trx,
2430: ra_cust_trx_types_all trx_type,
2431: ra_customer_trx_all trx,
2432: ra_customer_trx_lines_all line
2433: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2434: and trx_type.type = 'CM'

Line 3868: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

3864: SELECT INV_TYPE.CUST_TRX_TYPE_ID,
3865: INV_TYPE.TAX_CALCULATION_FLAG
3866: INTO l_cust_trx_type_id,
3867: l_tax_calculation_flag
3868: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
3869: WHERE INV_TYPE.CUST_TRX_TYPE_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index)
3870: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index);
3871:
3872: EXCEPTION