APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 174: FROM pn_payment_items_all item,

170: item.actual_amount,
171: item.payment_schedule_id,
172: schedule.schedule_date,
173: schedule.payment_status_lookup_code
174: FROM pn_payment_items_all item,
175: pn_payment_schedules_all schedule
176: WHERE item.payment_term_id = p_term_id
177: AND item.payment_schedule_id = schedule.payment_schedule_id
178: AND item.payment_item_type_lookup_code = 'CASH'

Line 839: FROM pn_payment_items_all item,

835: SELECT item.payment_item_id,
836: item.actual_amount amount,
837: schedule.payment_schedule_id,
838: schedule.schedule_date
839: FROM pn_payment_items_all item,
840: pn_payment_schedules_all schedule
841: WHERE schedule.payment_schedule_id = item.payment_schedule_id
842: AND schedule.payment_status_lookup_code = 'DRAFT'
843: AND item.payment_item_id IN

Line 1077: FROM pn_payment_items_all

1073: CURSOR check_if_sch_belong_to_term(p_sch_id pn_payment_schedules.payment_schedule_id%TYPE) IS
1074: SELECT 'Y'
1075: FROM dual
1076: WHERE EXISTS (SELECT NULL
1077: FROM pn_payment_items_all
1078: WHERE payment_schedule_id = p_sch_id
1079: AND payment_term_id = p_term_id);
1080:
1081: CURSOR org_id_cur IS

Line 1370: UPDATE pn_payment_items_all

1366: EXIT;
1367: END LOOP;
1368:
1369: FORALL i IN 0 .. l_payment_id_tbl.COUNT - 1
1370: UPDATE pn_payment_items_all
1371: SET actual_amount = ROUND(l_act_amt_tbl(i), l_precision),
1372: estimated_amount = ROUND(l_est_amt_tbl(i), l_precision),
1373: last_update_date = SYSDATE,
1374: last_updated_by = fnd_global.user_id,

Line 1444: INSERT INTO pn_payment_items_all

1440:
1441: END LOOP;
1442:
1443: FORALL i IN 0 .. l_sched_id_tbl.COUNT - 1
1444: INSERT INTO pn_payment_items_all
1445: (
1446: payment_item_id,
1447: last_update_date,
1448: last_updated_by,

Line 1777: FROM pn_payment_items_all item

1773: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1774:
1775: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1776: SELECT payment_item_id
1777: FROM pn_payment_items_all item
1778: WHERE item.payment_schedule_id = p_sch_id;
1779:
1780: l_found BOOLEAN;
1781:

Line 1826: FROM pn_payment_items_all item

1822: IS
1823:
1824: CURSOR find_cash_items (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS
1825: SELECT SUM(DECODE(item.payment_item_type_lookup_code, 'CASH', 1, 0)) num_cash
1826: FROM pn_payment_items_all item
1827: WHERE item.payment_schedule_id = p_sch_id;
1828:
1829: CURSOR get_term_data IS
1830: SELECT vendor_id,

Line 1931: INSERT INTO pn_payment_items_all

1927: EXIT;
1928:
1929: END LOOP;
1930:
1931: INSERT INTO pn_payment_items_all
1932: (
1933: payment_item_id,
1934: last_update_date,
1935: last_updated_by,