DBA Data[Home] [Help]

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on HR_ORGANIZATION_UNITS

Line 451: l_org_name hr_organization_units.name%TYPE;

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;
454: l_name hr_all_organization_units.name%TYPE;
455: l_full_path VARCHAR(500);

Line 464: FROM hr_organization_units

460: WHERE GL.set_of_books_id = p_cc_header_rec.set_of_books_id;
461:
462: CURSOR c_validate_org_id IS
463: SELECT name
464: FROM hr_organization_units
465: WHERE organization_id = p_cc_header_rec.org_id;
466:
467: CURSOR c_validate_sob_org_combo IS
468: SELECT HAOU.name