APPS.IBY_EXT_BANKACCT_PUB dependencies on HR_OPERATING_UNITS

Line 1336: l_org_name hr_operating_units.name%TYPE;

1332:
1333: l_error_msg VARCHAR2(500);
1334: l_ret_stat VARCHAR2(1);
1335: l_org_id iby_external_payees_all.org_id%TYPE;
1336: l_org_name hr_operating_units.name%TYPE;
1337: -- picks up branch number
1338: CURSOR c_branch (p_branch_id NUMBER) IS
1339: SELECT bank_or_branch_number
1340: FROM hz_organization_profiles

Line 1498: select name into l_org_name from hr_operating_units where organization_id = l_org_id;

1494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1495: print_debuginfo('l_org_id'||l_org_id);
1496: END IF;
1497: IF l_org_id <> -1 THEN
1498: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
1499: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
1500: fnd_message.set_Token('OU', l_org_name);
1501: fnd_msg_pub.add;
1502: END IF;

Line 2284: l_org_name hr_operating_units.name%TYPE;

2280:
2281: l_error_msg VARCHAR2(500);
2282: l_ret_stat VARCHAR2(1);
2283: l_org_id iby_external_payees_all.org_id%TYPE;
2284: l_org_name hr_operating_units.name%TYPE;
2285: -- Get Object Version Number
2286: CURSOR c_ovn (p_acct_id NUMBER) IS
2287: SELECT object_version_number,
2288: bank_account_num_hash1,

Line 2696: select name into l_org_name from hr_operating_units where organization_id = l_org_id;

2692: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2693: print_debuginfo('l_org_id::'||l_org_id);
2694: END IF;
2695: IF l_org_id <> -1 THEN
2696: select name into l_org_name from hr_operating_units where organization_id = l_org_id;
2697: fnd_message.set_name('IBY', 'IBY_UNIQ_ACCOUNT_OU');
2698: fnd_message.set_Token('OU',l_org_name);
2699: fnd_msg_pub.add;
2700: END IF;