APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_SUP_HDRS_ALL

Line 718: FROM JAI_AR_SUP_HDRS_ALL

714: FROM RA_CUSTOMER_TRX_ALL
715: WHERE customer_trx_id = pr_new.customer_trx_id;
716: CURSOR GET_SITE(P_TRX_NUMBER VARCHAR2) IS
717: SELECT customer_site
718: FROM JAI_AR_SUP_HDRS_ALL
719: WHERE supplementary_num = TO_NUMBER(p_trx_number);
720: -------------- cursor for st forms tracking -------------
721: CURSOR GET_EXCHANGE_RATE IS
722: SELECT exchange_rate

Line 783: JAI_AR_SUP_HDRS_ALL B,

779: CURSOR JA_IN_RA_CUSTOMER_TRX_INFOCNSL IS
780: SELECT A.organization_id,
781: A.Location_id
782: FROM JAI_AR_TRXS A,
783: JAI_AR_SUP_HDRS_ALL B,
784: RA_CUSTOMER_TRX_ALL C
785: WHERE pr_new.customer_trx_id = c.customer_trx_id
786: AND c.trx_number = TO_CHAR(B.SUPPLEMENTARY_NUM)
787: AND B.customer_trx_id = A.customer_trx_id;

Line 823: JAI_AR_SUP_HDRS_ALL b,

819: SELECT SUM(NVL(A.excise_diff_amt,0))+SUM(NVL(A.other_diff_amt,0)) TAX_AMT,
820: NVL(A.excise_diff_amt,0) excise_diff,
821: A.new_assessable_value
822: FROM JAI_AR_SUP_LINES A,
823: JAI_AR_SUP_HDRS_ALL b,
824: ra_customer_trx_all c,
825: ra_cust_trx_types_all e
826: WHERE pr_new.customer_trx_id = c.customer_trx_id
827: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)

Line 840: JAI_AR_SUP_HDRS_ALL b,

836:
837: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
838: SELECT A.tax_category_id
839: FROM JAI_AR_SUP_LINES A,
840: JAI_AR_SUP_HDRS_ALL b,
841: ra_customer_trx_all c,
842: ra_cust_trx_types_all D
843: WHERE pr_new.customer_trx_id = c.customer_trx_id
844: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)

Line 932: JAI_AR_SUP_HDRS_ALL c,

928: t.tax_type,
929: t.stform_type
930: FROM JAI_AR_SUP_TAXES A,
931: JAI_AR_SUP_LINES b,
932: JAI_AR_SUP_HDRS_ALL c,
933: ra_customer_trx_all D,
934: ra_cust_trx_types_all e,
935: JAI_CMN_TAXES_ALL t
936: WHERE pr_new.customer_trx_id = D.customer_trx_id

Line 981: JAI_AR_SUP_HDRS_ALL B,

977: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
978: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
979: SELECT 1
980: FROM JAI_AR_SUP_LINES A,
981: JAI_AR_SUP_HDRS_ALL B,
982: RA_CUSTOMER_TRX_ALL C,
983: RA_CUST_TRX_TYPES_ALL D
984: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
985: AND c.cust_trx_type_id = D.cust_trx_type_id

Line 1008: JAI_AR_SUP_HDRS_ALL B,

1004:
1005: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
1006: SELECT 1
1007: FROM JAI_AR_SUP_LINES A,
1008: JAI_AR_SUP_HDRS_ALL B,
1009: RA_CUSTOMER_TRX_ALL C,
1010: RA_CUST_TRX_TYPES_ALL D,
1011: JAI_AR_SUP_TAXES E
1012: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id