APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_LEASES

Line 45: l_cal_yr_st_dt pn_leases_all.cal_start%type;

41: l_freq_num NUMBER;
42:
43: l_info VARCHAR2(100);
44: l_desc VARCHAR2(100) := 'pn_retro_adjustment_pkg.create_virtual_schedules';
45: l_cal_yr_st_dt pn_leases_all.cal_start%type;
46: l_yr_start_dt DATE;
47: l_sch_str_dt DATE := NULL;
48:
49: BEGIN

Line 73: FROM PN_LEASES_ALL

69: pnp_debug_pkg.log(l_info);
70:
71: SELECT cal_start
72: INTO l_cal_yr_st_dt
73: FROM PN_LEASES_ALL
74: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_id);
75:
76:
77: IF l_cal_yr_st_dt IS NOT NULL THEN

Line 1080: p_lease_id pn_leases.lease_id%TYPE,

1076: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1077: -- 10-AUG-05 piagrawa o Bug #4284035 - Passed org id of the lease to insert_row
1078: ------------------------------------------------------------------------------+
1079: PROCEDURE find_schedule (
1080: p_lease_id pn_leases.lease_id%TYPE,
1081: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1082: p_term_id pn_payment_terms.payment_term_id%TYPE,
1083: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
1084: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE

Line 1104: FROM pn_leases_all

1100: AND payment_term_id = p_term_id);
1101:
1102: CURSOR org_id_cur IS
1103: SELECT org_id
1104: FROM pn_leases_all
1105: WHERE lease_id = p_lease_id;
1106:
1107: l_rowid VARCHAR2(100);
1108: l_found BOOLEAN := FALSE;

Line 1210: p_lease_id pn_leases.lease_id%TYPE,

1206: -- HISTORY :
1207: -- 05-OCT-04 ftanudja o Created.
1208: ------------------------------------------------------------------------------+
1209: PROCEDURE get_schedule_id_for_new_items(
1210: p_lease_id pn_leases.lease_id%TYPE,
1211: p_term_id pn_payment_terms.payment_term_id%TYPE,
1212: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1213: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1214: )

Line 1787: PROCEDURE cleanup_schedules(p_lease_id pn_leases_all.lease_id%TYPE)

1783: -- 08-OCT-04 piagrawa o Bug 4354810 - Overloaded for mini -retro.
1784: -- 04-APR-06 piagrawa o Bug#5107134 - modified schedules_draft_cur to include
1785: -- status 'ON_HOLD'
1786: ------------------------------------------------------------------------------+
1787: PROCEDURE cleanup_schedules(p_lease_id pn_leases_all.lease_id%TYPE)
1788: IS
1789:
1790: CURSOR schedules_draft_cur IS
1791: SELECT payment_schedule_id

Line 2119: FROM pn_leases_all

2115: AND payment_status_lookup_code = 'APPROVED';
2116:
2117: CURSOR org_id_cur IS
2118: SELECT org_id
2119: FROM pn_leases_all
2120: WHERE lease_id = p_lease_id;
2121:
2122: l_virtual_sched payment_item_tbl_type;
2123: l_current_sched payment_item_tbl_type;