APPS.PN_MASS_APPR_PKG dependencies on DUAL

Line 353: FROM DUAL

349: -------------------------------------------------------------------------------
350: CURSOR check_bill_term ( p_schedule_id IN NUMBER
351: ,p_ship_address_rule IN VARCHAR) IS
352: SELECT 'Y'
353: FROM DUAL
354: WHERE EXISTS (SELECT NULL
355: FROM pn_payment_terms_all ppt,
356: pn_payment_items_all ppi
357: WHERE ppi.payment_term_id = ppt.payment_term_id

Line 376: FROM dual

372: -- In a Payment Term vendor and vendor site must be defined
373: -------------------------------------------------------------------------------
374: CURSOR check_pay_term (p_schedule_id IN NUMBER) IS
375: SELECT 'Y'
376: FROM dual
377: WHERE EXISTS (SELECT NULL
378: FROM pn_payment_terms_all ppt,
379: pn_payment_items_all ppi
380: WHERE ppi.payment_term_id = ppt.payment_term_id

Line 395: FROM dual

391: -- should have a not null actual amount.
392: -------------------------------------------------------------------------------
393: CURSOR check_act_amt (p_schedule_id IN NUMBER) IS
394: SELECT 'Y'
395: FROM dual
396: WHERE EXISTS(SELECT NULL
397: FROM pn_payment_items_all ppi
398: WHERE ppi.payment_schedule_id = p_schedule_id
399: AND ppi.actual_amount IS NULL);