APPS.IGC_CC_COMMON_UTILS_PVT dependencies on AP_SYSTEM_PARAMETERS

Line 515: FROM AP_SYSTEM_PARAMETERS)

511: SELECT DISTINCT period_year
512: INTO l_fiscal_year_invoice
513: FROM gl_period_statuses
514: WHERE set_of_books_id = (SELECT set_of_books_id
515: FROM AP_SYSTEM_PARAMETERS)
516: AND l_gl_date BETWEEN START_DATE AND END_DATE;
517: EXCEPTION
518: WHEN OTHERS THEN
519: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

Line 559: FROM AP_SYSTEM_PARAMETERS)

555: SELECT DISTINCT period_year
556: INTO l_fiscal_year_pf
557: FROM gl_period_statuses
558: WHERE set_of_books_id = (SELECT set_of_books_id
559: FROM AP_SYSTEM_PARAMETERS)
560: AND l_CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE;
561: EXCEPTION
562: WHEN OTHERS THEN
563: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

Line 608: FROM AP_SYSTEM_PARAMETERS)

604: SELECT DISTINCT period_year
605: INTO l_fiscal_year_pf
606: FROM gl_period_statuses
607: WHERE set_of_books_id = (SELECT set_of_books_id
608: FROM AP_SYSTEM_PARAMETERS)
609: AND l_pf_date BETWEEN START_DATE AND END_DATE;
610: EXCEPTION
611: WHEN OTHERS THEN
612: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

Line 675: FROM AP_SYSTEM_PARAMETERS)

671: SELECT DISTINCT period_year
672: INTO l_fiscal_year_pf
673: FROM gl_period_statuses
674: WHERE set_of_books_id = (SELECT set_of_books_id
675: FROM AP_SYSTEM_PARAMETERS)
676: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

Line 727: FROM AP_SYSTEM_PARAMETERS)

723: SELECT DISTINCT period_year
724: INTO l_fiscal_year_pf
725: FROM gl_period_statuses
726: WHERE set_of_books_id = (SELECT set_of_books_id
727: FROM AP_SYSTEM_PARAMETERS)
728: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
729: EXCEPTION
730: WHEN OTHERS THEN
731: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

Line 778: FROM AP_SYSTEM_PARAMETERS)

774: SELECT DISTINCT period_year
775: INTO l_fiscal_year_pf
776: FROM gl_period_statuses
777: WHERE set_of_books_id = (SELECT set_of_books_id
778: FROM AP_SYSTEM_PARAMETERS)
779: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
780: EXCEPTION
781: WHEN OTHERS THEN
782: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

Line 845: FROM AP_SYSTEM_PARAMETERS)

841: SELECT DISTINCT period_year
842: INTO l_fiscal_year_pf
843: FROM gl_period_statuses
844: WHERE set_of_books_id = (SELECT set_of_books_id
845: FROM AP_SYSTEM_PARAMETERS)
846: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');