DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 681: FROM hr_organization_information

677: RETURN BOOLEAN
678: IS
679: CURSOR csr_exists IS
680: SELECT '1'
681: FROM hr_organization_information
682: WHERE organization_id = p_organization_id
683: AND org_information_context = 'CLASS'
684: AND org_information1 = p_org_class
685: AND org_information2 = 'Y';

Line 2126: FROM hr_organization_information

2122: IS
2123: CURSOR c_bank_name
2124: IS
2125: SELECT hr_general.decode_lookup('IN_BANK',org_information1)
2126: FROM hr_organization_information
2127: WHERE org_information_context = 'PER_IN_CHALLAN_BANK'
2128: AND org_information_id = p_org_information_id;
2129:
2130: l_bank_name VARCHAR2(300);