APPS.PNT_PAYMENT_SCHEDULES_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 136: FROM pn_payment_items_all

132: ) IS
133:
134: CURSOR is_actual_amount_NULL IS
135: SELECT 'x'
136: FROM pn_payment_items_all
137: WHERE payment_item_type_lookup_code = 'CASH'
138: AND payment_schedule_id = x_payment_schedule_id
139: AND NVL(actual_amount,0) = 0;
140:

Line 235: UPDATE pn_payment_items_all

231: IS
232:
233: BEGIN
234:
235: UPDATE pn_payment_items_all
236: SET export_to_ap_flag = x_export_flag
237: WHERE payment_schedule_id = x_payment_schedule_id
238: AND payment_item_type_lookup_code = 'CASH';
239:

Line 279: UPDATE pn_payment_items_all

275: IS
276:
277: BEGIN
278:
279: UPDATE pn_payment_items_all
280: SET export_to_ar_flag = x_export_flag
281: WHERE payment_schedule_id = x_payment_schedule_id
282: AND payment_item_type_lookup_code = 'CASH';
283:

Line 381: FROM pn_payment_items_all

377: l_item_exists VARCHAR2(1):='N';
378:
379: CURSOR payment_cursor IS
380: SELECT actual_amount, currency_code, rate, due_date
381: FROM pn_payment_items_all
382: WHERE payment_schedule_id = p_payment_schedule_id
383: AND payment_item_type_lookup_code = 'CASH';
384:
385: CURSOR chk_item_exists IS

Line 389: FROM pn_payment_items_all

385: CURSOR chk_item_exists IS
386: SELECT 'Y'
387: FROM dual
388: WHERE EXISTS (SELECT null
389: FROM pn_payment_items_all
390: WHERE payment_schedule_id = p_payment_schedule_id
391: AND payment_item_type_lookup_code = 'CASH'
392: AND currency_code <> p_functional_currency);
393:

Line 985: FROM pn_payment_items_all

981: , currency_code
982: , due_date
983: , rate
984: , payment_term_id
985: FROM pn_payment_items_all
986: WHERE payment_schedule_id = p_pnt_sched_id
987: AND payment_item_type_lookup_code = 'CASH';
988:
989: --Added for BUG#2590872

Line 994: FROM pn_payment_items_all pi,

990: CURSOR norm_cursor(l_term_id NUMBER, l_item_id number) IS
991: SELECT pi.payment_item_id
992: , pi.accounted_amount
993: , pi.actual_amount
994: FROM pn_payment_items_all pi,
995: pn_payment_items_all pi1
996: WHERE pi.payment_schedule_id = p_pnt_sched_id
997: AND pi.payment_TERM_id = l_term_id
998: AND pi.payment_item_type_lookup_code = 'NORMALIZED'

Line 995: pn_payment_items_all pi1

991: SELECT pi.payment_item_id
992: , pi.accounted_amount
993: , pi.actual_amount
994: FROM pn_payment_items_all pi,
995: pn_payment_items_all pi1
996: WHERE pi.payment_schedule_id = p_pnt_sched_id
997: AND pi.payment_TERM_id = l_term_id
998: AND pi.payment_item_type_lookup_code = 'NORMALIZED'
999: AND pi1.payment_schedule_id = pi.payment_schedule_id

Line 1072: UPDATE pn_payment_items_all

1068: END IF;
1069:
1070: --ADDED FOR BUG#2590872
1071: IF (NVL(v_accounted_amount,0) <> NVL(l_temp1,0)) THEN
1072: UPDATE pn_payment_items_all
1073: SET accounted_amount = l_temp1,
1074: accounted_date = l_date,
1075: RATE = payment_item_rec.RATE,
1076: CURRENCY_CODE = payment_item_rec.currency_code,

Line 1087: UPDATE pn_payment_items_all

1083: NULL;
1084: END IF;
1085: END IF;
1086: IF (NVL(payment_item_rec.accounted_amount,0) <> NVL(l_temp,0)) THEN
1087: UPDATE pn_payment_items_all
1088: SET accounted_amount = l_temp,
1089: accounted_date = l_date,
1090: last_updated_by = p_last_updated_by,
1091: last_update_date = p_last_update_date,

Line 1129: FROM pn_payment_items_all

1125: l_type VARCHAR2(30);
1126:
1127: CURSOR payment_cursor IS
1128: SELECT payment_item_id, currency_code, due_date, rate
1129: FROM pn_payment_items_all
1130: WHERE payment_schedule_id = p_pnt_sched_id
1131: AND payment_item_type_lookup_code = 'CASH';
1132:
1133: CURSOR org_cur IS

Line 1178: UPDATE pn_payment_items_all

1174: l_rate := NULL;
1175: END IF;
1176:
1177: IF (NVL(payment_item_rec.rate,0) <> NVL(l_rate,0)) THEN
1178: UPDATE pn_payment_items_all
1179: SET rate = l_rate,
1180: last_updated_by = p_last_updated_by,
1181: last_update_date = p_last_update_date,
1182: last_update_login = p_last_update_login