APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 195: FROM pn_payment_items_all item,

191: item.actual_amount,
192: item.payment_schedule_id,
193: schedule.schedule_date,
194: schedule.payment_status_lookup_code
195: FROM pn_payment_items_all item,
196: pn_payment_schedules_all schedule
197: WHERE item.payment_term_id = p_term_id
198: AND item.payment_schedule_id = schedule.payment_schedule_id
199: AND item.payment_item_type_lookup_code = 'CASH'

Line 860: FROM pn_payment_items_all item,

856: SELECT item.payment_item_id,
857: item.actual_amount amount,
858: schedule.payment_schedule_id,
859: schedule.schedule_date
860: FROM pn_payment_items_all item,
861: pn_payment_schedules_all schedule
862: WHERE schedule.payment_schedule_id = item.payment_schedule_id
863: AND schedule.payment_status_lookup_code = 'DRAFT'
864: AND item.payment_item_id IN

Line 1098: FROM pn_payment_items_all

1094: CURSOR check_if_sch_belong_to_term(p_sch_id pn_payment_schedules.payment_schedule_id%TYPE) IS
1095: SELECT 'Y'
1096: FROM dual
1097: WHERE EXISTS (SELECT NULL
1098: FROM pn_payment_items_all
1099: WHERE payment_schedule_id = p_sch_id
1100: AND payment_term_id = p_term_id);
1101:
1102: CURSOR org_id_cur IS

Line 1391: UPDATE pn_payment_items_all

1387: EXIT;
1388: END LOOP;
1389:
1390: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1391: UPDATE pn_payment_items_all
1392: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1393: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1394: last_update_date = SYSDATE,
1395: last_updated_by = fnd_global.user_id,

Line 1465: INSERT INTO pn_payment_items_all

1461:
1462: END LOOP;
1463:
1464: FORALL i IN 0 .. l_sched_id_tbl.COUNT - 1
1465: INSERT INTO pn_payment_items_all
1466: (
1467: payment_item_id,
1468: last_update_date,
1469: last_updated_by,

Line 1798: FROM pn_payment_items_all item

1794: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1795:
1796: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1797: SELECT payment_item_id
1798: FROM pn_payment_items_all item
1799: WHERE item.payment_schedule_id = p_sch_id;
1800:
1801: l_found BOOLEAN;
1802:

Line 1847: FROM pn_payment_items_all item

1843: IS
1844:
1845: CURSOR find_cash_items (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1846: SELECT SUM(DECODE(item.payment_item_type_lookup_code, 'CASH', 1, 0)) num_cash
1847: FROM pn_payment_items_all item
1848: WHERE item.payment_schedule_id = p_sch_id;
1849:
1850: CURSOR get_term_data IS
1851: SELECT vendor_id,

Line 1952: INSERT INTO pn_payment_items_all

1948: EXIT;
1949:
1950: END LOOP;
1951:
1952: INSERT INTO pn_payment_items_all
1953: (
1954: payment_item_id,
1955: last_update_date,
1956: last_updated_by,