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 125: FROM pn_distributions_all pd

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

Line 5153: FROM pn_distributions_all

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

Line 5159: FROM pn_distributions_all

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

Line 6237: DELETE FROM pn_distributions_all

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