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_PAYMENT_ITEMS_ALL

Line 2545: pn_payment_items_all ppi

2541: ,ip_normalize IN VARCHAR2
2542: ,ip_index_period_id IN NUMBER)IS
2543: SELECT ppt.payment_term_id, ppt.actual_amount,ppt.frequency_code
2544: FROM pn_payment_terms_all ppt,
2545: pn_payment_items_all ppi
2546: WHERE ppt.index_period_id = ip_index_period_id
2547: AND ppt.status =c_payment_term_status_approved
2548: AND ppt.index_term_indicator = ip_index_term_indicator
2549: AND ppt.payment_purpose_code = ip_payment_purpose_code

Line 3205: FROM pn_payment_items_all item,

3201: ,p_distribution_string VARCHAR2
3202: ,p_normalize pn_payment_terms.normalize%TYPE
3203: ) IS
3204: SELECT sum(item.actual_amount) sum_overlap_amt
3205: FROM pn_payment_items_all item,
3206: pn_payment_terms_all term
3207: WHERE item.payment_term_id = term.payment_term_id
3208: AND item.due_date BETWEEN p_assessment_date AND p_end_date
3209: AND term.index_period_id = p_index_period_id

Line 4198: FROM pn_payment_items_all item,

4194: p_overlap_amt OUT NOCOPY NUMBER)
4195: IS
4196: CURSOR get_overlap_sum IS
4197: SELECT sum(item.actual_amount) sum_overlap_amt
4198: FROM pn_payment_items_all item,
4199: pn_payment_terms_all term
4200: WHERE item.payment_term_id = term.payment_term_id
4201: AND term.term_template_id = p_term_template_id
4202: AND term.index_period_id = p_index_period_id