APPS.PN_DISTRIBUTION_ACCOUNT dependencies on PN_DISTRIBUTIONS_ALL

Line 324: FROM pn_distributions_all

320: CURSOR chk_exists IS
321: SELECT'Y'
322: FROM dual
323: WHERE EXISTS (SELECT NULL
324: FROM pn_distributions_all
325: WHERE payment_term_id = p_payment_term_id
326: AND account_class = p_accnt_class);
327:
328: l_exists VARCHAR2(30) := 'N';

Line 357: FROM pn_distributions_all

353:
354: l_context := 'getting line NUMBER';
355: SELECT NVL(MAX (line_number),0) + 1
356: INTO l_line_number
357: FROM pn_distributions_all
358: WHERE payment_term_id = p_payment_term_id;
359:
360: pnp_debug_pkg.log('Line Number : ' || TO_CHAR(l_line_number) );
361:

Line 372: INSERT INTO pn_distributions_all (distribution_id,

368: ELSE
369: l_org_ID := p_org_id;
370: END IF;
371:
372: INSERT INTO pn_distributions_all (distribution_id,
373: payment_term_id,
374: account_id,
375: account_class,
376: percentage,