APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_SUP_TAXES

Line 974: FROM JAI_AR_SUP_TAXES A,

970: A.diff_amt,
971: A.diff_amt FUNC_TAX_AMT,
972: t.tax_type,
973: t.stform_type
974: FROM JAI_AR_SUP_TAXES A,
975: JAI_AR_SUP_LINES b,
976: ra_customer_trx_all C,
977: ra_cust_trx_types_all D,
978: JAI_CMN_TAXES_ALL t

Line 998: FROM JAI_AR_SUP_TAXES A,

994: SUM(A.diff_amt) DIFF_AMT,
995: SUM(A.diff_amt) FUNC_TAX_AMT,
996: t.tax_type,
997: t.stform_type
998: FROM JAI_AR_SUP_TAXES A,
999: JAI_AR_SUP_LINES b,
1000: JAI_AR_SUP_HDRS_ALL c,
1001: ra_customer_trx_all D,
1002: ra_cust_trx_types_all e,

Line 1069: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b

1065: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1066:
1067: CURSOR SUPPLEMENT_TAX_LINES_CHECK IS
1068: SELECT 1
1069: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b
1070: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
1071: AND b.customer_trx_line_id = v_customer_Trx_line_id;
1072:
1073: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS

Line 1079: JAI_AR_SUP_TAXES E

1075: FROM JAI_AR_SUP_LINES A,
1076: JAI_AR_SUP_HDRS_ALL B,
1077: RA_CUSTOMER_TRX_ALL C,
1078: RA_CUST_TRX_TYPES_ALL D,
1079: JAI_AR_SUP_TAXES E
1080: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
1081: AND c.cust_trx_type_id = D.cust_trx_type_id
1082: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)
1083: AND b.supp_inv_type = DECODE(D.TYPE,'INV','SI','CM','CR','DM','DB')