DBA Data[Home] [Help]

APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on FND_PROFILE

Line 149: WHERE hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

145: IS
146: SELECT hou.organization_id
147: FROM hr_organization_units hou
148: ,hr_organization_information hoi
149: WHERE hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
150: AND hoi.organization_id = hou.organization_id
151: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
152: AND hoi.org_information1 = p_tan_number;
153:

Line 771: SELECT FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

767: RETURN NUMBER
768: IS
769: CURSOR c_bg
770: IS
771: SELECT FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
772: FROM dual;
773: --
774: l_bg NUMBER;
775: l_procedure VARCHAR2(250);