APPS.PN_NORM_RENORM_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 156: FROM pn_lease_details_all

152: IF l_amd_comn_date IS NULL
153: THEN
154: SELECT lease_commencement_date
155: INTO l_amd_comn_date
156: FROM pn_lease_details_all
157: WHERE lease_id = p_lease_id;
158: END IF;
159:
160: pnp_debug_pkg.log(' l_amd_comn_date : ' || l_amd_comn_date );

Line 180: --pn_lease_details_all where lease_id = p_lease_id );

176: AND pps.payment_schedule_id = ppi.payment_schedule_id
177: AND pps.payment_status_lookup_code <> 'DRAFT'
178: AND schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp); /* 8491119 */
179: --AND schedule_date <= (SELECT last_day(lease_termination_date) from /* 11742270 */
180: --pn_lease_details_all where lease_id = p_lease_id );
181:
182: pnp_debug_pkg.log('l_app_amt : ' || l_app_amt);
183:
184: --Draft schedules should not be deleted before ACD

Line 1054: pn_lease_details_all pld

1050: SELECT pld.lease_commencement_date lease_commencement_date,
1051: pld.lease_termination_date new_lease_term_date,
1052: pl.payment_term_proration_rule pr_rule
1053: FROM pn_leases_all pl,
1054: pn_lease_details_all pld
1055: WHERE pl.lease_id = p_lease_id
1056: AND pld.lease_id = pl.lease_id;
1057:
1058: l_counter NUMBER;

Line 1069: l_lease_comm_date pn_lease_details_all.lease_commencement_date%TYPE;

1065:
1066: l_org_id NUMBER;
1067:
1068: -- Bug#6829173
1069: l_lease_comm_date pn_lease_details_all.lease_commencement_date%TYPE;
1070: l_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE;
1071: lp_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE := NULL;
1072:
1073:

Line 1090: FROM pn_lease_details_all

1086: IF l_amd_comn_date IS NULL
1087: THEN
1088: SELECT lease_commencement_date
1089: INTO l_amd_comn_date
1090: FROM pn_lease_details_all
1091: WHERE lease_id = p_lease_id;
1092: END IF;
1093:
1094: IF l_amd_comn_date > p_norm_str_dt THEN /* 6838211 */