DBA Data[Home] [Help]

APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_ITEMS

Line 7: item_id pn_payment_items.payment_item_id%TYPE,

3:
4: ------------------------------ DECLARATIONS ----------------------------------+
5:
6: TYPE payment_item_rec IS RECORD(
7: item_id pn_payment_items.payment_item_id%TYPE,
8: start_date pn_payment_items.adj_start_date%TYPE,
9: end_date pn_payment_items.adj_end_date%TYPE,
10: trx_date pn_payment_items.due_date%TYPE,
11: amount pn_payment_terms.actual_amount%TYPE,

Line 8: start_date pn_payment_items.adj_start_date%TYPE,

4: ------------------------------ DECLARATIONS ----------------------------------+
5:
6: TYPE payment_item_rec IS RECORD(
7: item_id pn_payment_items.payment_item_id%TYPE,
8: start_date pn_payment_items.adj_start_date%TYPE,
9: end_date pn_payment_items.adj_end_date%TYPE,
10: trx_date pn_payment_items.due_date%TYPE,
11: amount pn_payment_terms.actual_amount%TYPE,
12: new_amount pn_payment_terms.actual_amount%TYPE,

Line 9: end_date pn_payment_items.adj_end_date%TYPE,

5:
6: TYPE payment_item_rec IS RECORD(
7: item_id pn_payment_items.payment_item_id%TYPE,
8: start_date pn_payment_items.adj_start_date%TYPE,
9: end_date pn_payment_items.adj_end_date%TYPE,
10: trx_date pn_payment_items.due_date%TYPE,
11: amount pn_payment_terms.actual_amount%TYPE,
12: new_amount pn_payment_terms.actual_amount%TYPE,
13: payment_status pn_payment_schedules.payment_status_lookup_code%TYPE,

Line 10: trx_date pn_payment_items.due_date%TYPE,

6: TYPE payment_item_rec IS RECORD(
7: item_id pn_payment_items.payment_item_id%TYPE,
8: start_date pn_payment_items.adj_start_date%TYPE,
9: end_date pn_payment_items.adj_end_date%TYPE,
10: trx_date pn_payment_items.due_date%TYPE,
11: amount pn_payment_terms.actual_amount%TYPE,
12: new_amount pn_payment_terms.actual_amount%TYPE,
13: payment_status pn_payment_schedules.payment_status_lookup_code%TYPE,
14: schedule_date pn_payment_schedules.schedule_date%TYPE,

Line 33: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE

29: p_term_sch_day pn_payment_terms.schedule_day%TYPE,
30: p_term_act_amt pn_payment_terms.actual_amount%TYPE,
31: p_term_freq pn_payment_terms.frequency_code%TYPE,
32: p_term_hist_id pn_payment_terms_history.term_history_id%TYPE,
33: p_adj_type_cd pn_payment_items.last_adjustment_type_code%TYPE
34: );
35:
36: PROCEDURE find_schedule (
37: p_lease_id pn_leases.lease_id%TYPE,