DBA Data[Home] [Help]

APPS.PN_OPEX_TERMS_PKG dependencies on PN_DISTRIBUTIONS_ALL

Line 63: FROM pn_distributions_all

59:
60: CURSOR distributions_cur (term_temp_id IN NUMBER)
61: IS
62: SELECT *
63: FROM pn_distributions_all
64: WHERE term_template_id = term_temp_id;
65:
66:
67:

Line 663: FROM pn_distributions_all

659:
660: CURSOR distributions_cur (term_temp_id IN NUMBER)
661: IS
662: SELECT *
663: FROM pn_distributions_all
664: WHERE term_template_id = term_temp_id;
665:
666:
667: -- Using the last estimated payment term to default the values in case present.

Line 1238: delete from pn_distributions_all

1234:
1235: delete from pn_opex_est_payments_all
1236: where payment_term_id = prev_pay_term_id;
1237:
1238: delete from pn_distributions_all
1239: where payment_term_id = prev_pay_term_id;
1240:
1241: delete from pn_payment_terms_all
1242: where payment_term_id = prev_pay_term_id;