APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 469: FROM hr_organization_information OOD,

465: WHERE organization_id = p_cc_header_rec.org_id;
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)

Line 2082: FROM hr_organization_information OOD,

2078: l_validation_level NUMBER;
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)

Line 3219: FROM hr_organization_information OOD,

3215: AND ICH.cc_num = p_cc_num;
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)

Line 3404: FROM hr_organization_information OOD,

3400: ICH.cc_ref_num = p_cc_ref_num;
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)