APPS.IGC_CC_COMMON_UTILS_PVT dependencies on IGC_CC_DET_PF

Line 377: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */

373: RETURN BOOLEAN
374: IS
375:
376: l_cc_num po_headers.segment1%type; /* cc number */
377: l_pf_date igc_cc_det_pf.cc_det_pf_date%type; /* Payment forecast date */
378: l_CC_STATE igc_cc_headers.cc_state%type;
379: l_CC_CTRL_STATUS igc_cc_headers.CC_CTRL_STATUS%type;
380: l_CC_ENCMBRNC_STATUS igc_cc_headers.CC_ENCMBRNC_STATUS%type;
381: l_CC_APPRVL_STATUS igc_cc_headers.CC_APPRVL_STATUS%type;

Line 388: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;

384: l_fiscal_year_pf gl_period_statuses.period_year%type; /* fiscal year of specific Payment Forecast line */
385: l_period gl_period_statuses.period_name%TYPE;
386: l_open_gl_date gl_period_statuses.start_date%type; /* Holds the next open gl date */
387: l_gl_date gl_period_statuses.start_date%type;
388: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;
389: l_shipment_num po_line_locations_all.shipment_num%type;
390: l_line_location_id po_line_locations_all.line_location_id%type;
391:
392: -- Cursor to get the account line id value

Line 541: FROM IGC_CC_DET_PF

537: * po_distributions*/
538: BEGIN
539: SELECT CC_DET_PF_DATE
540: INTO l_cc_det_pf_date
541: FROM IGC_CC_DET_PF
542: WHERE CC_acct_LINE_ID = c_acct_line1.cc_acct_line_id
543: AND cc_det_pf_line_num = c_for_each_dist_in_po1.distribution_num;
544:
545: EXCEPTION

Line 585: FROM IGC_CC_DET_PF

581: BEGIN
582: /* Get the Payment Forecast Date for that particular distribution line*/
583: SELECT CC_DET_PF_DATE
584: INTO l_pf_date
585: FROM IGC_CC_DET_PF
586: WHERE CC_acct_LINE_ID = (SELECT CC_acct_LINE_ID
587: FROM IGC_CC_ACCT_LINES
588: WHERE cc_header_id = (SELECT cc_header_id
589: FROM IGC_CC_HEADERS

Line 658: FROM igc_cc_det_pf

654: LOOP
655: BEGIN
656: SELECT cc_det_pf_date
657: INTO l_cc_det_pf_date
658: FROM igc_cc_det_pf
659: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
660: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
661: EXCEPTION
662: WHEN OTHERS THEN

Line 711: FROM igc_cc_det_pf

707: LOOP
708: BEGIN
709: SELECT cc_det_pf_date
710: INTO l_cc_det_pf_date
711: FROM igc_cc_det_pf
712: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
713: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
714: EXCEPTION
715: WHEN OTHERS THEN

Line 762: FROM igc_cc_det_pf

758: LOOP
759: BEGIN
760: SELECT cc_det_pf_date
761: INTO l_cc_det_pf_date
762: FROM igc_cc_det_pf
763: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
764: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
765: EXCEPTION
766: WHEN OTHERS THEN

Line 829: FROM igc_cc_det_pf

825: LOOP
826: BEGIN
827: SELECT cc_det_pf_date
828: INTO l_cc_det_pf_date
829: FROM igc_cc_det_pf
830: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
831: AND cc_det_pf_line_num = x_po_dist_num;
832: EXCEPTION
833: WHEN OTHERS THEN