DBA Data[Home] [Help]

APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_ADJUSTMENT_SUMMARIES_S

Line 187: FROM pn_adjustment_summaries summary

183: CURSOR fetch_adj_items IS
184: SELECT summary.adjustment_summary_id,
185: summary.adj_schedule_date,
186: summary.sum_adj_amount
187: FROM pn_adjustment_summaries summary
188: WHERE summary.payment_term_id = p_term_id
189: ORDER BY summary.adj_schedule_date;
190:
191: l_orig_item_tbl payment_item_tbl_type;

Line 1647: pn_adjustment_summaries_s.nextval,

1643: last_update_date,
1644: last_updated_by,
1645: last_update_login
1646: ) VALUES (
1647: pn_adjustment_summaries_s.nextval,
1648: p_adj_table(i).schedule_date,
1649: p_term_id,
1650: p_adj_table(i).amount,
1651: SYSDATE,