APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUSTOMER_TRX_ALL

Line 593: FROM ra_customer_trx_all

589: INTO X_customertrx_line_id
590: FROM dual;
591:
592: SELECT org_id into l_org_id
593: FROM ra_customer_trx_all
594: Where customer_trx_id = x_new_customer_trx_id;
595:
596: INSERT INTO ra_customer_trx_lines (
597: customer_trx_line_id,

Line 650: FROM ra_customer_trx_all where

646: ) IS
647: l_org_id NUMBER(15);
648: BEGIN
649: SELECT org_id into l_org_id
650: FROM ra_customer_trx_all where
651: customer_trx_id = x_new_cust_trx_id;
652:
653: INSERT INTO ra_cust_trx_line_salesreps (
654: cust_trx_line_salesrep_id,

Line 747: SELECT org_id into l_org_id from ra_customer_trx_all where

743: l_org_id NUMBER(15);
744:
745: BEGIN
746:
747: SELECT org_id into l_org_id from ra_customer_trx_all where
748: customer_trx_id = x_customer_trx_id;
749: SELECT chart_of_accounts_id into x_struct_num FROM gl_sets_of_books
750: WHERE set_of_books_id = x_set_of_books_id;
751:

Line 955: ra_customer_trx_all

951:
952: /* Replace Insert by AR's table handler. Bug # 2249731 */
953:
954: SELECT org_id into l_org_id from
955: ra_customer_trx_all
956: where customer_trx_id = X_customer_trx_id;
957: l_ps_rec.last_update_date := sysdate;
958: l_ps_rec.last_updated_by := X_user_id;
959: l_ps_rec.creation_date := sysdate;