APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on DUAL

Line 388: FROM sys.dual;

384:
385: BEGIN
386: /* SELECT ra_customer_trx_s.nextval
387: INTO X_new_cust_trx_id
388: FROM sys.dual;
389: */
390:
391: X_trx_number := jl_br_ar_generate_debit_memo.generate_interest_DM_number(X_inv_cust_trx_id,
392: X_payment_schedule_id);

Line 590: FROM dual;

586: l_org_id NUMBER(15);
587: BEGIN
588: SELECT ra_customer_trx_lines_s.nextval
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;

Line 769: FROM sys.dual;

765: BEGIN
766: X_custtrx_line_id := X_customer_trx_line_id;
767: SELECT ra_cust_trx_line_salesreps_s.nextval
768: INTO X_line_salesrepid
769: FROM sys.dual;
770: END;
771: END IF;
772:
773: /* Check if this transaction has to be posted to GL */

Line 879: FROM sys.dual;

875: X_due_date DATE;
876: BEGIN
877: SELECT ar_payment_schedules_s.nextval
878: INTO X_payment_scheduleid
879: FROM sys.dual;
880:
881:
882: /* INSERT INTO ar_payment_schedules (
883: payment_schedule_id,

Line 1045: from dual;

1041:
1042: BEGIN
1043: select to_date(X_interest_date,'DD-MM-YYYY')
1044: into X_interest_DM_date
1045: from dual;
1046:
1047: -----------------------------------------------------
1048: -- Bug 3378555. Retrieves information for the invoice
1049: -- currency code.