eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_SCHEDULES_ITEMS dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 615: FROM pn_payment_schedules_all pps,

611:
612: CURSOR lst_sch_dt_cur (p_term_id NUMBER)
613: IS
614: SELECT MAX(pps.schedule_date), COUNT(pps.schedule_date)
615: FROM pn_payment_schedules_all pps,
616: pn_payment_items_all ppi
617: WHERE ppi.payment_term_id = p_term_id
618: AND pps.payment_schedule_id = ppi.payment_schedule_id
619: AND ppi.actual_amount <> 0

Line 627: FROM pn_payment_schedules_all pps

623: p_start_date DATE)
624: IS
625:
626: SELECT First_Day(MIN(pps.schedule_date))
627: FROM pn_payment_schedules_all pps
628: WHERE pps.lease_id = p_lease_id
629: AND First_Day(pps.schedule_date) >= First_Day(p_start_date)
630: AND TO_CHAR(pps.schedule_date,'DD') = p_sch_day
631: AND pps.payment_status_lookup_code = 'DRAFT';

Line 638: FROM pn_payment_schedules_all pps

634: p_start_date DATE)
635: IS
636:
637: SELECT ADD_MONTHS(First_Day(MAX(pps.schedule_date)) , 1)
638: FROM pn_payment_schedules_all pps
639: WHERE pps.lease_id = p_lease_id
640: AND First_Day(pps.schedule_date) >= First_Day(p_start_date)
641: AND TO_CHAR(pps.schedule_date,'DD') = p_sch_day
642: AND pps.payment_status_lookup_code = 'APPROVED';

Line 1360: FROM pn_payment_schedules_all

1356:
1357: CURSOR check_sch IS
1358: SELECT payment_schedule_id,
1359: payment_status_lookup_code
1360: FROM pn_payment_schedules_all
1361: WHERE schedule_date = p_sch_dt
1362: AND lease_id = p_lease_id
1363: ORDER BY payment_status_lookup_code DESC;
1364:

Line 1374: pn_payment_schedules_all sched

1370:
1371: CURSOR sched_exists(p_payment_term_id NUMBER,p_sch_dt DATE) IS
1372: SELECT sched.payment_schedule_id
1373: FROM pn_payment_items_all item,
1374: pn_payment_schedules_all sched
1375: WHERE item.payment_term_id = p_payment_term_id
1376: AND item.payment_schedule_id = sched.payment_schedule_id
1377: AND sched.schedule_date = p_sch_dt;
1378:

Line 1400: INSERT INTO pn_payment_schedules_all

1396: FROM DUAL;
1397:
1398: l_pymnt_st_lkp_cd := 'DRAFT';
1399:
1400: INSERT INTO pn_payment_schedules_all
1401:
1402: (payment_schedule_id,
1403: last_update_date,
1404: last_updated_by,

Line 1453: FROM pn_payment_schedules_all

1449:
1450: SELECT payment_schedule_id,
1451: payment_status_lookup_code
1452: INTO l_sch_id, l_pymnt_st_lkp_cd
1453: FROM pn_payment_schedules_all
1454: WHERE lease_id = p_lease_id
1455: AND schedule_date = l_schd_date
1456: AND payment_status_lookup_code = l_pymnt_st_lkp_cd
1457: AND ROWNUM = 1;

Line 1463: INSERT INTO pn_payment_schedules_all(

1459: EXCEPTION WHEN NO_DATA_FOUND THEN
1460: SELECT pn_payment_schedules_s.NEXTVAL INTO l_sch_id
1461: FROM DUAL;
1462:
1463: INSERT INTO pn_payment_schedules_all(
1464: payment_schedule_id,
1465: last_update_date,
1466: last_updated_by,
1467: creation_date,

Line 1798: pn_payment_schedules_all pps

1794:
1795: SELECT NVL(SUM(ppi.actual_amount),0)
1796: INTO l_la_amt
1797: FROM pn_payment_items_all ppi,
1798: pn_payment_schedules_all pps
1799: WHERE ppi.payment_term_id = p_term_id
1800: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
1801: AND pps.payment_schedule_id = ppi.payment_schedule_id
1802: AND pps.payment_status_lookup_code <> 'DRAFT'; --Bug#6825797 'APPROVED';

Line 1821: pn_payment_schedules_all pps

1817:
1818: SELECT LEAST(p_norm_end_dt, NVL(LAST_DAY(MAX(pps.schedule_date)), p_norm_end_dt))
1819: INTO l_norm_end_dt
1820: FROM pn_payment_items_all ppi,
1821: pn_payment_schedules_all pps
1822: WHERE ppi.payment_term_id = p_term_id
1823: AND pps.payment_schedule_id = ppi.payment_schedule_id
1824: AND pps.payment_status_lookup_code = 'DRAFT';
1825:

Line 1831: pn_payment_schedules_all pps

1827:
1828: SELECT COUNT(*)
1829: INTO l_app_sch
1830: FROM pn_payment_items_all ppi,
1831: pn_payment_schedules_all pps
1832: WHERE ppi.payment_term_id = p_term_id
1833: AND pps.payment_schedule_id = ppi.payment_schedule_id
1834: AND pps.payment_status_lookup_code = 'APPROVED'
1835: AND ppi.payment_item_type_lookup_code = 'CASH'

Line 1839: FROM pn_payment_schedules_all ppsi,

1835: AND ppi.payment_item_type_lookup_code = 'CASH'
1836: AND pps.schedule_date between First_Day(p_norm_str_dt) and LAST_DAY(l_norm_end_dt)
1837: AND NOT EXISTS (
1838: SELECT 1
1839: FROM pn_payment_schedules_all ppsi,
1840: pn_payment_items_all ppii
1841: WHERE ppsi.schedule_date = pps.schedule_date
1842: AND ppii.payment_term_id = ppi.payment_term_id
1843: AND ppsi.payment_schedule_id = ppii.payment_schedule_id

Line 1938: pn_payment_schedules_all pps

1934:
1935: DELETE pn_payment_items_all ppi
1936: WHERE ppi.payment_schedule_id IN (SELECT pps.payment_schedule_id
1937: FROM pn_payment_items_all ppi1,
1938: pn_payment_schedules_all pps
1939: WHERE ppi1.payment_term_id = p_term_id
1940: AND ppi1.payment_item_type_lookup_code = 'CASH'
1941: AND pps.payment_schedule_id = ppi1.payment_schedule_id
1942: AND pps.payment_status_lookup_code = 'DRAFT')

Line 2087: FROM pn_payment_schedules_all pps,

2083: ppi.last_update_date = SYSDATE,
2084: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2085: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2086: WHERE ppi.payment_schedule_id IN (SELECT pps.payment_schedule_id
2087: FROM pn_payment_schedules_all pps,
2088: pn_payment_items_all ppi1
2089: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id
2090: AND pps.payment_status_lookup_code = 'DRAFT'
2091: AND ppi1.payment_term_id = p_term_id)

Line 2118: FROM pn_payment_schedules_all pps,

2114: ppi.last_update_date = SYSDATE,
2115: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2116: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2117: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2118: FROM pn_payment_schedules_all pps,
2119: pn_payment_items_all ppi1
2120: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id
2121: AND pps.payment_status_lookup_code = 'DRAFT'
2122: AND ppi1.payment_term_id = p_term_id

Line 2152: FROM pn_payment_schedules_all pps,

2148: ppi.last_update_date = SYSDATE,
2149: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2150: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2151: WHERE ppi.payment_schedule_id = (SELECT pps.payment_schedule_id
2152: FROM pn_payment_schedules_all pps,
2153: pn_payment_items_all ppi1
2154: WHERE pps.payment_schedule_id = ppi1.payment_schedule_id
2155: AND pps.payment_status_lookup_code = 'DRAFT'
2156: AND ppi1.payment_term_id = p_term_id

Line 2754: pn_payment_schedules_all pps

2750: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2751: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
2752: WHERE payment_item_id = (SELECT ppi1.payment_item_id
2753: FROM pn_payment_items_all ppi1,
2754: pn_payment_schedules_all pps
2755: WHERE ppi1.payment_term_id = p_term_id
2756: AND ppi1.payment_item_type_lookup_code = 'CASH'
2757: AND pps.payment_status_lookup_code = 'DRAFT'
2758: AND pps.payment_schedule_id = ppi1.payment_schedule_id

Line 2807: FROM pn_payment_schedules_all pps,

2803: AND frequency_code <> 'OT';
2804:
2805: CURSOR get_last_schedule (p_payment_term_id NUMBER) IS
2806: SELECT MAX(schedule_date)
2807: FROM pn_payment_schedules_all pps,
2808: pn_payment_items_all ppi
2809: WHERE ppi.payment_term_id = p_payment_term_id
2810: AND ppi.payment_item_type_lookup_code = 'CASH'
2811: AND ppi.actual_amount <> 0

Line 3331: FROM pn_payment_schedules_all

3327: pnp_debug_pkg.log('CON - MAIN - Deleting Payment Items');
3328:
3329: DELETE pn_payment_items_all
3330: WHERE payment_schedule_id IN (SELECT payment_schedule_id
3331: FROM pn_payment_schedules_all
3332: WHERE lease_id = p_lease_id
3333: AND schedule_date > p_new_lea_term_dt
3334: AND payment_status_lookup_code = 'DRAFT')
3335: AND payment_term_id NOT IN (SELECT payment_term_id

Line 3345: DELETE pn_payment_schedules_all psch

3341: and schedule date is greater than lease termination date. */
3342:
3343: pnp_debug_pkg.log('CON - MAIN - Deleting Payment Schedules');
3344:
3345: DELETE pn_payment_schedules_all psch
3346: WHERE lease_id = p_lease_id
3347: AND schedule_date > p_new_lea_term_dt
3348: AND payment_status_lookup_code = 'DRAFT'
3349: AND NOT EXISTS (SELECT null

Line 3609: FROM pn_payment_schedules_all

3605: pnp_debug_pkg.log('+++++++++++Deleting All Items for term:'||l_item_end_dt_tbl(i).term_id||
3606: ' with schedule_date > ' ||l_item_end_dt_tbl(i).item_end_dt);
3607: DELETE pn_payment_items_all
3608: WHERE payment_schedule_id IN (SELECT payment_schedule_id
3609: FROM pn_payment_schedules_all
3610: WHERE lease_id = p_lease_id
3611: AND schedule_date > l_item_end_dt_tbl(i).item_end_dt
3612: AND payment_status_lookup_code = 'DRAFT')
3613: AND payment_term_id = l_item_end_dt_tbl(i).term_id;

Line 3622: DELETE pn_payment_schedules_all psch

3618:
3619: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Deleting Payment Schedules');
3620: pnp_debug_pkg.log('+++++++++++Deleting Draft Empty Schedules for lease:'||p_lease_id||
3621: ' with schedule_date > '||p_new_lea_term_dt);
3622: DELETE pn_payment_schedules_all psch
3623: WHERE lease_id = p_lease_id
3624: AND schedule_date > p_new_lea_term_dt
3625: AND payment_status_lookup_code = 'DRAFT'
3626: AND NOT EXISTS (SELECT 1

Line 3641: pn_payment_schedules_all schd

3637: AND start_date > p_new_lea_term_dt
3638: AND index_period_id IS NULL
3639: AND NOT EXISTS(SELECT 1
3640: FROM pn_payment_items_all item,
3641: pn_payment_schedules_all schd
3642: WHERE item.payment_term_id = term.payment_term_id
3643: AND item.payment_schedule_id = schd.payment_schedule_id
3644: AND schd.payment_status_lookup_code = 'APPROVED');
3645:

Line 3857: FROM pn_payment_schedules_all pps

3853: AND changes.lease_change_id = details.lease_change_id;
3854:
3855: CURSOR get_last_appr_schd_dt (p_lease_id NUMBER) IS
3856: SELECT MAX(pps.schedule_date) lst_schedule_date
3857: FROM pn_payment_schedules_all pps
3858: WHERE pps.payment_status_lookup_code = 'APPROVED'
3859: AND pps.lease_id = p_lease_id;
3860:
3861: -- Bug 7184211

Line 3867: FROM pn_payment_schedules_all pps

3863: p_start_date DATE)
3864: IS
3865:
3866: SELECT First_Day(MIN(pps.schedule_date))
3867: FROM pn_payment_schedules_all pps
3868: WHERE pps.lease_id = p_lease_id
3869: AND First_Day(pps.schedule_date) >= First_Day(p_start_date)
3870: AND TO_CHAR(pps.schedule_date,'DD') = l_schd_day
3871: AND pps.payment_status_lookup_code = 'DRAFT';

Line 4572: FROM pn_payment_schedules_all pps,

4568: CURSOR lst_cash_sch_dt_cur (p_term_id NUMBER,
4569: p_term_end_dt DATE)
4570: IS
4571: SELECT MAX(pps.schedule_date)
4572: FROM pn_payment_schedules_all pps,
4573: pn_payment_items_all ppi
4574: WHERE pps.payment_schedule_id = ppi.payment_schedule_id
4575: AND ppi.payment_term_id = p_term_id
4576: AND ppi.actual_amount IS NOT NULL

Line 4665: pn_payment_schedules_all pps

4661: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
4662: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
4663: WHERE payment_item_id IN (SELECT ppi1.payment_item_id
4664: FROM pn_payment_items_all ppi1,
4665: pn_payment_schedules_all pps
4666: WHERE ppi1.payment_term_id = pay_term_con_cur.payment_term_id
4667: AND ppi1.payment_item_type_lookup_code = 'CASH'
4668: AND pps.payment_status_lookup_code = 'DRAFT'
4669: AND pps.payment_schedule_id = ppi1.payment_schedule_id

Line 4679: FROM pn_payment_schedules_all pps1,

4675:
4676: DELETE pn_payment_items_all ppi
4677: WHERE ppi.payment_term_id = pay_term_con_cur.payment_term_id
4678: AND ppi.payment_schedule_id IN (SELECT pps1.payment_schedule_id
4679: FROM pn_payment_schedules_all pps1,
4680: pn_payment_items_all ppi1
4681: WHERE ppi1.payment_term_id = pay_term_con_cur.payment_term_id
4682: AND pps1.payment_schedule_id = ppi1.payment_schedule_id
4683: AND pps1.payment_status_lookup_code = 'DRAFT'

Line 4686: DELETE pn_payment_schedules_all pps

4682: AND pps1.payment_schedule_id = ppi1.payment_schedule_id
4683: AND pps1.payment_status_lookup_code = 'DRAFT'
4684: AND pps1.schedule_date > l_lst_cash_sch_dt);
4685:
4686: DELETE pn_payment_schedules_all pps
4687: WHERE pps.lease_id = p_lease_id
4688: AND pps.payment_schedule_id IN (SELECT pps1.payment_schedule_id
4689: FROM pn_payment_schedules_all pps1
4690: WHERE pps1.lease_id = p_lease_id

Line 4689: FROM pn_payment_schedules_all pps1

4685:
4686: DELETE pn_payment_schedules_all pps
4687: WHERE pps.lease_id = p_lease_id
4688: AND pps.payment_schedule_id IN (SELECT pps1.payment_schedule_id
4689: FROM pn_payment_schedules_all pps1
4690: WHERE pps1.lease_id = p_lease_id
4691: AND TO_NUMBER(TO_CHAR(pps1.schedule_date,'DD'))
4692: = pay_term_con_cur.schedule_day
4693: AND pps1.schedule_date > l_lst_cash_sch_dt

Line 4850: FROM pn_payment_schedules_all

4846: l_found_apprvd_sch BOOLEAN := FALSE;
4847:
4848: CURSOR check_sch_date (p_schedule_date DATE) IS
4849: SELECT payment_schedule_id
4850: FROM pn_payment_schedules_all
4851: WHERE lease_id = p_lease_id
4852: AND schedule_date = p_schedule_date
4853: AND payment_status_lookup_code = 'APPROVED';
4854: BEGIN

Line 5158: pn_payment_schedules_all ps

5154:
5155: CURSOR exist_appr_item_amt IS
5156: SELECT NVL(SUM(pi.actual_amount),0) amount
5157: FROM pn_payment_items_all pi,
5158: pn_payment_schedules_all ps
5159: WHERE pi.payment_term_id = p_payment_term_rec.payment_term_id
5160: AND pi.payment_schedule_id = ps.payment_schedule_id
5161: AND ps.schedule_date = l_sch_dt
5162: AND ps.payment_status_lookup_code = 'APPROVED';

Line 5373: DELETE FROM PN_PAYMENT_SCHEDULES_ALL

5369: p_sob_id => p_payment_term_rec.set_of_books_id,
5370: p_curr_code => p_payment_term_rec.currency_code,
5371: p_rate => p_payment_term_rec.rate);
5372: ELSE
5373: DELETE FROM PN_PAYMENT_SCHEDULES_ALL
5374: WHERE payment_schedule_id = l_sch_id;
5375: END IF;
5376:
5377: END IF; /* NOT(l_rec_found) */

Line 5567: FROM pn_payment_schedules_all sch,

5563: AND end_date = p_date;
5564:
5565: CURSOR last_sch_cur (p_term_id NUMBER) IS
5566: SELECT MAX(sch.schedule_date)
5567: FROM pn_payment_schedules_all sch,
5568: pn_payment_items_all itm
5569: WHERE itm.payment_term_id = p_term_id
5570: AND itm.payment_schedule_id = sch.payment_schedule_id
5571: AND itm.payment_item_type_lookup_code = 'CASH';

Line 5594: l_payment_status pn_payment_schedules_all.payment_status_lookup_code%TYPE;

5590: l_freq NUMBER;
5591: l_no_of_sch NUMBER;
5592: l_last_sch_date DATE;
5593: l_duration_in_months NUMBER;
5594: l_payment_status pn_payment_schedules_all.payment_status_lookup_code%TYPE;
5595: l_create_term_flag VARCHAR2(1);
5596:
5597: BEGIN
5598:

Line 5684: from pn_payment_schedules_all

5680: OPEN last_sch_cur(l_payment_term_rec.payment_term_id);
5681: FETCH last_sch_cur INTO l_last_sch_date;
5682:
5683: select payment_status_lookup_code INTO l_payment_status
5684: from pn_payment_schedules_all
5685: where schedule_date = l_last_sch_date
5686: and lease_id = p_lease_id;
5687:
5688: CLOSE last_sch_cur;

Line 5978: pn_payment_schedules_all pps,

5974: DECODE(ppt.normalize,'Y',NVL(ppi.actual_amount,0), 0), 0)) cash_norm_amt,
5975: SUM(DECODE(ppi.payment_item_type_lookup_code, 'NORMALIZED',
5976: NVL(ppi.actual_amount,0), 0)) norm_amt
5977: FROM pn_payment_items_all ppi,
5978: pn_payment_schedules_all pps,
5979: pn_payment_terms_all ppt
5980: WHERE ppt.lease_id = g_lease_id
5981: AND ppt.lease_id = pps.lease_id
5982: AND pps.payment_schedule_id = ppi.payment_schedule_id

Line 6340: pn_payment_schedules_all pps

6336: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
6337: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
6338: WHERE payment_item_id = (SELECT ppi.payment_item_id
6339: FROM pn_payment_items_all ppi,
6340: pn_payment_schedules_all pps
6341: WHERE ppi.payment_term_id = p_term_id
6342: AND ppi.payment_item_type_lookup_code = 'CASH'
6343: AND pps.payment_schedule_id = ppi.payment_schedule_id
6344: AND pps.payment_status_lookup_code = 'DRAFT'

Line 6504: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%TYPE;

6500: l_lease_termination_date DATE;
6501: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
6502: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;
6503: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
6504: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%TYPE;
6505: l_adjustment VARCHAR2(1);
6506: l_adj_amount NUMBER;
6507:
6508: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;

Line 6523: FROM pn_payment_schedules_all pps

6519:
6520: /* check if exists draft schedule for the given date for a lease */
6521: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS
6522: SELECT pps.payment_schedule_id
6523: FROM pn_payment_schedules_all pps
6524: WHERE pps.schedule_date = p_sched_date
6525: AND pps.lease_id = p_lease_id
6526: AND pps.payment_status_lookup_code = 'DRAFT';
6527:

Line 6558: FROM pn_payment_schedules_all

6554: /* delete items beyond the end date */
6555: DELETE pn_payment_items_all
6556: WHERE payment_schedule_id IN
6557: (SELECT payment_schedule_id
6558: FROM pn_payment_schedules_all
6559: WHERE lease_id = p_lease_id
6560: AND schedule_date > pay_term_con_cur.end_date
6561: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
6562: AND payment_term_id = pay_term_con_cur.payment_term_id;

Line 6670: FROM pn_payment_schedules_all

6666: /* Added for Bug 6154106*/
6667: DELETE pn_payment_items_all
6668: WHERE payment_schedule_id IN
6669: (SELECT payment_schedule_id
6670: FROM pn_payment_schedules_all
6671: WHERE lease_id = p_lease_id
6672: AND schedule_date > g_new_lea_term_dt
6673: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
6674: AND payment_term_id = pay_term_con_cur.payment_term_id;

Line 6678: FROM pn_payment_schedules_all pps,

6674: AND payment_term_id = pay_term_con_cur.payment_term_id;
6675: l_count := 0;
6676: -- Copied from PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE
6677: SELECT count(*) into l_count
6678: FROM pn_payment_schedules_all pps,
6679: pn_payment_items_all ppi
6680: WHERE pps.lease_id = p_lease_id
6681: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(l_norm_str_dt)
6682: AND LAST_DAY(g_new_lea_term_dt)

Line 6796: FROM pn_payment_schedules_all

6792: -- retrieves the approved schedule for a payment term for a lease
6793: CURSOR approved_sched_exist_cur(p_lease_ID IN NUMBER, p_payment_term_id IN NUMBER)
6794: IS
6795: SELECT payment_schedule_id
6796: FROM pn_payment_schedules_all
6797: WHERE lease_id = p_lease_ID
6798: AND payment_status_lookup_code = 'APPROVED'
6799: AND payment_schedule_id IN (SELECT payment_schedule_id
6800: FROM pn_payment_items_all