APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on IGC_CC_SYSTEM_OPTIONS_ALL

Line 448: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;

444: l_conversion_date DATE;
445: l_set_of_books_id NUMBER;
446: l_user_id NUMBER;
447: l_login_id NUMBER;
448: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
449: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
450: l_cc_num_created NUMBER;
451: l_org_name hr_organization_units.name%TYPE;
452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

Line 449: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;

445: l_set_of_books_id NUMBER;
446: l_user_id NUMBER;
447: l_login_id NUMBER;
448: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
449: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
450: l_cc_num_created NUMBER;
451: l_org_name hr_organization_units.name%TYPE;
452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
453: l_cc_num igc_cc_headers.cc_num%TYPE;

Line 664: FROM igc_cc_system_options_all CCNM

660: SELECT CCNM.cc_num_method,
661: CCNM.cc_num_datatype
662: INTO l_cc_num_method,
663: l_cc_num_datatype
664: FROM igc_cc_system_options_all CCNM
665: WHERE CCNM.org_id = p_current_org_id;
666:
667: EXCEPTION
668: WHEN OTHERS THEN

Line 1547: FROM igc_cc_system_options_all ccsp

1543:
1544: BEGIN
1545: SELECT ccsp.default_rate_type
1546: INTO x_conversion_type
1547: FROM igc_cc_system_options_all ccsp
1548: WHERE ccsp.org_id = p_cc_header_rec.org_id;
1549:
1550: EXCEPTION
1551: