APPS.PN_MASS_APPR_PKG dependencies on RA_BATCH_SOURCES

Line 417: FROM RA_BATCH_SOURCES

413: -- this will be used in check_bill_term
414: -------------------------------------------------------------------------------
415: CURSOR csr_ship_address_rule IS
416: SELECT NVL(ship_address_rule,'None') AS ship_address_rule
417: FROM RA_BATCH_SOURCES
418: WHERE batch_source_id = 24;
419:
420: /* --- VARIABLES --- */
421: TYPE currency_tbl_type

Line 433: l_ship_cust_rule RA_BATCH_SOURCES.ship_address_rule%TYPE;

429: l_sch_rej NUMBER;
430: l_sch_tot NUMBER;
431:
432: /* variables to hold validation values */
433: l_ship_cust_rule RA_BATCH_SOURCES.ship_address_rule%TYPE;
434: l_func_curr PN_CURRENCIES.currency_code%TYPE;
435: l_item_curr PN_CURRENCIES.currency_code%TYPE;
436: l_curr_conv_type PN_CURRENCIES.conversion_type%TYPE;
437:

Line 469: /* Get the Ship address rule from ra_batch_sources */

465: l_sch_app := 0;
466: l_sch_rej := 0;
467: l_sch_tot := 0;
468:
469: /* Get the Ship address rule from ra_batch_sources */
470: FOR rec IN csr_ship_address_rule LOOP
471: l_ship_cust_rule := rec.ship_address_rule;
472: END LOOP;
473: