APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on DUAL

Line 416: FROM sys.dual;

412:
413: BEGIN
414: /* SELECT ra_customer_trx_s.nextval
415: INTO X_new_cust_trx_id
416: FROM sys.dual;
417: */
418:
419: X_trx_number := jl_br_ar_generate_debit_memo.generate_interest_DM_number(X_inv_cust_trx_id,
420: X_payment_schedule_id);

Line 621: FROM dual;

617: l_org_id NUMBER(15);
618: BEGIN
619: SELECT ra_customer_trx_lines_s.nextval
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;

Line 808: FROM sys.dual;

804: BEGIN
805: X_custtrx_line_id := X_customer_trx_line_id;
806: SELECT ra_cust_trx_line_salesreps_s.nextval
807: INTO X_line_salesrepid
808: FROM sys.dual;
809: END;
810: END IF;
811:
812: /* Check if this transaction has to be posted to GL */

Line 918: FROM sys.dual;

914: X_due_date DATE;
915: BEGIN
916: SELECT ar_payment_schedules_s.nextval
917: INTO X_payment_scheduleid
918: FROM sys.dual;
919:
920:
921: /* INSERT INTO ar_payment_schedules (
922: payment_schedule_id,

Line 1085: from dual;

1081:
1082: BEGIN
1083: select to_date(X_interest_date,'DD-MM-YYYY')
1084: into X_interest_DM_date
1085: from dual;
1086:
1087: -----------------------------------------------------
1088: -- Bug 3378555. Retrieves information for the invoice
1089: -- currency code.