APPS.HR_SG_BANK_ACCT_VALIDATION dependencies on HR_LOOKUPS

Line 43: From hr_lookups

39: l_return VARCHAR2(5) := 'FALSE';
40:
41: CURSOR get_bank_code(p_bank_name VARCHAR2) IS
42: Select meaning
43: From hr_lookups
44: Where lookup_type = 'SG_BANK_CODE'
45: And lookup_code = p_bank_name
46: And application_id = 800
47: And enabled_flag = 'Y';

Line 60: -- Get bank code from HR_LOOKUPS

56: RAISE validation_failed;
57: END IF;
58:
59:
60: -- Get bank code from HR_LOOKUPS
61:
62: OPEN get_bank_code (p_bank_name);
63: FETCH get_bank_code
64: INTO l_bank_code;