APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_SUP_HDRS_ALL

Line 755: FROM JAI_AR_SUP_HDRS_ALL

751: FROM RA_CUSTOMER_TRX_ALL
752: WHERE customer_trx_id = pr_new.customer_trx_id;
753: CURSOR GET_SITE(P_TRX_NUMBER VARCHAR2) IS
754: SELECT customer_site
755: FROM JAI_AR_SUP_HDRS_ALL
756: WHERE TO_CHAR(supplementary_num) = p_trx_number; /*Added by abezgam for Bug# 11802779*/
757: --WHERE supplementary_num = TO_NUMBER(p_trx_number); /* Commented for Bug# 11802779*/
758:
759: -------------- cursor for st forms tracking -------------

Line 839: JAI_AR_SUP_HDRS_ALL B,

835: CURSOR JA_IN_RA_CUSTOMER_TRX_INFOCNSL IS
836: SELECT A.organization_id,
837: A.Location_id
838: FROM JAI_AR_TRXS A,
839: JAI_AR_SUP_HDRS_ALL B,
840: RA_CUSTOMER_TRX_ALL C
841: WHERE pr_new.customer_trx_id = c.customer_trx_id
842: AND c.trx_number = TO_CHAR(B.SUPPLEMENTARY_NUM)
843: AND B.customer_trx_id = A.customer_trx_id;

Line 889: JAI_AR_SUP_HDRS_ALL b,

885: SELECT SUM(NVL(A.excise_diff_amt,0))+SUM(NVL(A.other_diff_amt,0)) TAX_AMT,
886: NVL(A.excise_diff_amt,0) excise_diff,
887: A.new_assessable_value
888: FROM JAI_AR_SUP_LINES A,
889: JAI_AR_SUP_HDRS_ALL b,
890: ra_customer_trx_all c,
891: ra_cust_trx_types_all e
892: WHERE pr_new.customer_trx_id = c.customer_trx_id
893: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)

Line 908: JAI_AR_SUP_HDRS_ALL b,

904:
905: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
906: SELECT A.tax_category_id
907: FROM JAI_AR_SUP_LINES A,
908: JAI_AR_SUP_HDRS_ALL b,
909: ra_customer_trx_all c,
910: ra_cust_trx_types_all D
911: WHERE pr_new.customer_trx_id = c.customer_trx_id
912: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)

Line 1000: JAI_AR_SUP_HDRS_ALL c,

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,
1003: JAI_CMN_TAXES_ALL t
1004: WHERE pr_new.customer_trx_id = D.customer_trx_id

Line 1049: JAI_AR_SUP_HDRS_ALL B,

1045: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
1046: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
1047: SELECT 1
1048: FROM JAI_AR_SUP_LINES A,
1049: JAI_AR_SUP_HDRS_ALL B,
1050: RA_CUSTOMER_TRX_ALL C,
1051: RA_CUST_TRX_TYPES_ALL D
1052: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
1053: AND c.cust_trx_type_id = D.cust_trx_type_id

Line 1076: JAI_AR_SUP_HDRS_ALL B,

1072:
1073: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
1074: SELECT 1
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