APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUSTOMER_TRX_ALL

Line 624: FROM ra_customer_trx_all

620: INTO X_customertrx_line_id
621: FROM dual;
622:
623: SELECT org_id into l_org_id
624: FROM ra_customer_trx_all
625: Where customer_trx_id = x_new_customer_trx_id;
626:
627: INSERT INTO ra_customer_trx_lines (
628: customer_trx_line_id,

Line 681: FROM ra_customer_trx_all where

677: ) IS
678: l_org_id NUMBER(15);
679: BEGIN
680: SELECT org_id into l_org_id
681: FROM ra_customer_trx_all where
682: customer_trx_id = x_new_cust_trx_id;
683:
684: INSERT INTO ra_cust_trx_line_salesreps (
685: cust_trx_line_salesrep_id,

Line 779: SELECT org_id into l_org_id from ra_customer_trx_all where

775: l_org_id NUMBER(15);
776:
777: BEGIN
778:
779: SELECT org_id into l_org_id from ra_customer_trx_all where
780: customer_trx_id = x_customer_trx_id;
781: SELECT chart_of_accounts_id into x_struct_num FROM gl_sets_of_books
782: WHERE set_of_books_id = x_set_of_books_id;
783:

Line 994: ra_customer_trx_all

990:
991: /* Replace Insert by AR's table handler. Bug # 2249731 */
992:
993: SELECT org_id into l_org_id from
994: ra_customer_trx_all
995: where customer_trx_id = X_customer_trx_id;
996: l_ps_rec.last_update_date := sysdate;
997: l_ps_rec.last_updated_by := X_user_id;
998: l_ps_rec.creation_date := sysdate;