APPS.IGC_CC_COMMON_UTILS_PVT dependencies on AP_SYSTEM_PARAMETERS

Line 513: FROM AP_SYSTEM_PARAMETERS)

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

Line 557: FROM AP_SYSTEM_PARAMETERS)

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

Line 606: FROM AP_SYSTEM_PARAMETERS)

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

Line 673: FROM AP_SYSTEM_PARAMETERS)

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

Line 725: FROM AP_SYSTEM_PARAMETERS)

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

Line 776: FROM AP_SYSTEM_PARAMETERS)

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

Line 843: FROM AP_SYSTEM_PARAMETERS)

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