APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_LEASES_ALL

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 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 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;