APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_LEASES

Line 1059: p_lease_id pn_leases.lease_id%TYPE,

1055: -- 15-JUL-05 SatyaDeep o Replaced base views with their _ALL tables
1056: -- 10-AUG-05 piagrawa o Bug #4284035 - Passed org id of the lease to insert_row
1057: ------------------------------------------------------------------------------+
1058: PROCEDURE find_schedule (
1059: p_lease_id pn_leases.lease_id%TYPE,
1060: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1061: p_term_id pn_payment_terms.payment_term_id%TYPE,
1062: p_schedule_date pn_payment_schedules.schedule_date%TYPE,
1063: p_schedule_id OUT NOCOPY pn_payment_schedules.payment_schedule_id%TYPE

Line 1083: FROM pn_leases_all

1079: AND payment_term_id = p_term_id);
1080:
1081: CURSOR org_id_cur IS
1082: SELECT org_id
1083: FROM pn_leases_all
1084: WHERE lease_id = p_lease_id;
1085:
1086: l_rowid VARCHAR2(100);
1087: l_found BOOLEAN := FALSE;

Line 1189: p_lease_id pn_leases.lease_id%TYPE,

1185: -- HISTORY :
1186: -- 05-OCT-04 ftanudja o Created.
1187: ------------------------------------------------------------------------------+
1188: PROCEDURE get_schedule_id_for_new_items(
1189: p_lease_id pn_leases.lease_id%TYPE,
1190: p_term_id pn_payment_terms.payment_term_id%TYPE,
1191: p_lease_change_id pn_lease_changes.lease_change_id%TYPE,
1192: p_sched_tbl IN OUT NOCOPY payment_item_tbl_type
1193: )

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

1762: -- 08-OCT-04 piagrawa o Bug 4354810 - Overloaded for mini -retro.
1763: -- 04-APR-06 piagrawa o Bug#5107134 - modified schedules_draft_cur to include
1764: -- status 'ON_HOLD'
1765: ------------------------------------------------------------------------------+
1766: PROCEDURE cleanup_schedules(p_lease_id pn_leases_all.lease_id%TYPE)
1767: IS
1768:
1769: CURSOR schedules_draft_cur IS
1770: SELECT payment_schedule_id

Line 2098: FROM pn_leases_all

2094: AND payment_status_lookup_code = 'APPROVED';
2095:
2096: CURSOR org_id_cur IS
2097: SELECT org_id
2098: FROM pn_leases_all
2099: WHERE lease_id = p_lease_id;
2100:
2101: l_virtual_sched payment_item_tbl_type;
2102: l_current_sched payment_item_tbl_type;