APPS.IGC_CC_COMMON_UTILS_PVT dependencies on IGC_CC_DET_PF

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

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

Line 386: l_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%type;

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

Line 539: FROM IGC_CC_DET_PF

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

Line 583: FROM IGC_CC_DET_PF

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

Line 656: FROM igc_cc_det_pf

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

Line 709: FROM igc_cc_det_pf

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

Line 760: FROM igc_cc_det_pf

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

Line 827: FROM igc_cc_det_pf

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