APPS.IGC_CC_PO_INTERFACE_PKG dependencies on IGC_CC_DET_PF

Line 315: FROM igc_cc_det_pf

311: /* Current year payment forecast only */
312:
313: SELECT SUM(cc_det_pf_entered_amt)
314: INTO l_po_lines_rec.quantity
315: FROM igc_cc_det_pf
316: WHERE cc_acct_line_id = p_cc_acct_lines_rec.cc_acct_line_id AND
317: /* Commented this part of code to fix bug 1576123 (cc_det_pf_date >= p_yr_start_date AND */
318: ( cc_det_pf_date <= p_yr_end_date) ;
319:

Line 601: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,

597: PROCEDURE Initialize_Distributions_Row(p_mode IN VARCHAR2,
598: p_encumbrance_on IN VARCHAR2,
599: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
600: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
601: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
602: p_po_line_locs_rec IN po_line_locations_all%ROWTYPE,
603: p_po_dist_rec IN OUT NOCOPY po_distributions_all%ROWTYPE )
604: IS
605: l_po_dist_rec po_distributions_all%ROWTYPE;

Line 908: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c

904: l_curr_year_pf_lines := 0;
905:
906: SELECT count(cc_det_pf_line_id)
907: INTO l_curr_year_pf_lines
908: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c
909: WHERE
910: NVL(a.cc_det_pf_date,l_end_date + 1) <= l_end_date AND
911: a.cc_acct_line_id = b.cc_acct_line_id AND
912: b.cc_header_id = c.cc_header_id AND

Line 1174: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;

1170: l_api_version CONSTANT NUMBER := 1.0;
1171:
1172: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1173: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
1174: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
1175:
1176: l_po_headers_rec po_headers_all%ROWTYPE;
1177: l_po_lines_rec po_lines_all%ROWTYPE;
1178: l_po_line_locs_rec po_line_locations_all%ROWTYPE;

Line 1228: FROM igc_cc_det_pf

1224:
1225: /* Contract Commitment detail payment forecast */
1226: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
1227: SELECT *
1228: FROM igc_cc_det_pf
1229: WHERE cc_acct_line_id = t_cc_acct_line_id;
1230:
1231: /* Contract Commitment account lines */
1232:

Line 1392: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c

1388: /* begin fix for bug 1578214 */
1389:
1390: SELECT count(cc_det_pf_line_id)
1391: INTO l_curr_year_pf_lines
1392: FROM igc_cc_det_pf a, igc_cc_acct_lines b, igc_cc_headers c
1393: WHERE
1394: NVL(a.cc_det_pf_date,l_end_date + 1) <= l_end_date AND
1395: a.cc_acct_line_id = b.cc_acct_line_id AND
1396: b.cc_header_id = c.cc_header_id AND

Line 1482: FROM igc_cc_det_pf b

1478: l_curr_year_pf_lines := 0;
1479:
1480: SELECT count(*)
1481: INTO l_curr_year_pf_lines
1482: FROM igc_cc_det_pf b
1483: WHERE
1484: /* commented this part of code to fix bug 1576123 ( cc_det_pf_date >= l_start_date
1485: AND */
1486: (cc_det_pf_date <= l_end_date ) AND

Line 1767: FROM igc_cc_det_pf b

1763: l_curr_year_pf_lines := 0;
1764:
1765: SELECT count(*)
1766: INTO l_curr_year_pf_lines
1767: FROM igc_cc_det_pf b
1768: WHERE
1769: /* commented this part of code to fix bug 1576123 ( cc_det_pf_date >= l_start_date AND */
1770: (cc_det_pf_date <= l_end_date ) AND
1771: b.cc_acct_line_id = l_cc_acct_lines_rec.cc_acct_line_id;