eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 454: l_name hr_all_organization_units.name%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);
456:
457: CURSOR c_validate_sob_id IS
458: SELECT GL.set_of_books_id

Line 470: hr_all_organization_units HAOU

466:
467: CURSOR c_validate_sob_org_combo IS
468: SELECT HAOU.name
469: FROM hr_organization_information OOD,
470: hr_all_organization_units HAOU
471: WHERE OOD.organization_id = p_cc_header_rec.org_id
472: AND OOD.organization_id = HAOU.organization_id
473: AND OOD.org_information3 || '' = to_char(p_cc_header_rec.set_of_books_id)
474: AND HAOU.organization_id || '' = OOD.organization_id;

Line 2074: l_name hr_all_organization_units.name%TYPE;

2070: l_current_login_id NUMBER;
2071: l_user_id NUMBER;
2072: l_login_id NUMBER;
2073: -- l_debug_mode VARCHAR2(1);
2074: l_name hr_all_organization_units.name%TYPE;
2075: l_current_org_id NUMBER;
2076: l_init_msg_list varchar2(2000);
2077: l_commit varchar2(2000);
2078: l_validation_level NUMBER;

Line 2083: hr_all_organization_units HAOU

2079:
2080: CURSOR c_validate_sob_org_combo IS
2081: SELECT HAOU.name
2082: FROM hr_organization_information OOD,
2083: hr_all_organization_units HAOU
2084: WHERE OOD.organization_id = l_current_org_id
2085: AND OOD.organization_id = HAOU.organization_id
2086: AND OOD.org_information3 || '' = to_char(p_set_of_books_id)
2087: AND HAOU.organization_id || '' = OOD.organization_id;

Line 3220: hr_all_organization_units HAOU

3216:
3217: CURSOR c_validate_sob_org_combo IS
3218: SELECT HAOU.name
3219: FROM hr_organization_information OOD,
3220: hr_all_organization_units HAOU
3221: WHERE OOD.organization_id = p_org_id
3222: AND OOD.organization_id = HAOU.organization_id
3223: AND OOD.org_information3 || '' = to_char(p_set_of_books_id)
3224: AND HAOU.organization_id || '' = OOD.organization_id;

Line 3229: l_name hr_all_organization_units.name%TYPE;

3225:
3226: l_api_name VARCHAR2(30);
3227: l_api_version NUMBER;
3228: l_debug VARCHAR2 (1);
3229: l_name hr_all_organization_units.name%TYPE;
3230:
3231: l_full_path VARCHAR(500);
3232: l_init_msg_list varchar2(2000);
3233: l_commit varchar2(2000);

Line 3405: hr_all_organization_units HAOU

3401:
3402: CURSOR c_validate_sob_org_combo IS
3403: SELECT HAOU.name
3404: FROM hr_organization_information OOD,
3405: hr_all_organization_units HAOU
3406: WHERE OOD.organization_id = p_org_id
3407: AND OOD.organization_id = HAOU.organization_id
3408: AND OOD.org_information3 || '' = to_char(p_set_of_books_id)
3409: AND HAOU.organization_id || '' = OOD.organization_id;

Line 3417: l_name hr_all_organization_units.name%TYPE;

3413: l_debug VARCHAR2(1);
3414: l_cc_num igc_cc_headers.cc_num%TYPE;
3415: l_cc_ref_num igc_cc_headers.cc_ref_num%TYPE;
3416: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
3417: l_name hr_all_organization_units.name%TYPE;
3418:
3419: l_full_path VARCHAR(500);
3420: l_init_msg_list varchar2(2000);
3421: l_commit varchar2(2000);