eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_DISTRIBUTIONS_ALL

Line 126: FROM pn_distributions_all pd

122: SELECT pd.payment_term_id
123: ,pd.account_class
124: ,pd.account_id
125: ,pd.percentage
126: FROM pn_distributions_all pd
127: WHERE pd.payment_term_id = ip_payment_term_id
128: ORDER BY pd.account_class,
129: pd.account_id,
130: pd.percentage;

Line 5155: FROM pn_distributions_all

5151:
5152: CURSOR distributions (ip_term_template_id IN NUMBER)
5153: IS
5154: SELECT *
5155: FROM pn_distributions_all
5156: WHERE term_template_id = ip_term_template_id;
5157:
5158: CURSOR distributions_aggr (ip_payment_term_id IN NUMBER )
5159: IS

Line 5161: FROM pn_distributions_all

5157:
5158: CURSOR distributions_aggr (ip_payment_term_id IN NUMBER )
5159: IS
5160: SELECT *
5161: FROM pn_distributions_all
5162: WHERE payment_term_id = ip_payment_term_id;
5163:
5164: CURSOR get_location_id IS
5165: SELECT location_id

Line 6239: DELETE FROM pn_distributions_all

6235: DELETE FROM pn_index_lease_terms_all ilt
6236: WHERE ilt.index_period_id = c_rec.index_period_id
6237: AND ilt.approved_flag <> c_payment_term_status_approved ;
6238:
6239: DELETE FROM pn_distributions_all
6240: WHERE payment_term_id IN (SELECT payment_term_id
6241: FROM pn_payment_terms_all ppt
6242: WHERE ppt.index_period_id = c_rec.index_period_id
6243: AND ppt.status <> c_payment_term_status_approved);