APPS.PAY_IN_PROF_TAX_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 31: from hr_organization_information hoi

27: l_message VARCHAR2(255);
28:
29: CURSOR csr_state (p_pt_org IN VARCHAR2) IS
30: select hoi.org_information4
31: from hr_organization_information hoi
32: , hr_organization_units hou
33: where hoi.organization_id = p_pt_org
34: and hoi.organization_id = hou.organization_id
35: and hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 199: FROM hr_organization_information

195: l_dummy VARCHAR2(1);
196:
197: CURSOR c_dup_state IS
198: SELECT 'X'
199: FROM hr_organization_information
200: WHERE organization_id = p_organization_id
201: AND org_information_context = p_org_info_type_code
202: AND org_information1 = p_state
203: AND org_information2 = p_exemption_catg

Line 335: FROM hr_organization_information

331: l_dummy VARCHAR2(1);
332:
333: CURSOR c_dup_state IS
334: SELECT 'X'
335: FROM hr_organization_information
336: WHERE organization_id = p_organization_id
337: AND org_information_context = p_org_info_type_code
338: AND org_information1 = p_state
339: AND (p_org_information_id is NULL OR org_information_id <> p_org_information_id)

Line 652: FROM hr_organization_information

648: l_message VARCHAR2(255);
649:
650: CURSOR c_org_info IS
651: SELECT org_information1, org_information2
652: FROM hr_organization_information
653: WHERE organization_id = p_organization_id
654: AND org_information_context = p_org_info_type_code;
655:
656: l_org_information1 hr_organization_information.org_information1%TYPE;

Line 656: l_org_information1 hr_organization_information.org_information1%TYPE;

652: FROM hr_organization_information
653: WHERE organization_id = p_organization_id
654: AND org_information_context = p_org_info_type_code;
655:
656: l_org_information1 hr_organization_information.org_information1%TYPE;
657: l_org_information2 hr_organization_information.org_information2%TYPE;
658:
659: BEGIN
660: g_debug:= hr_utility.debug_enabled;

Line 657: l_org_information2 hr_organization_information.org_information2%TYPE;

653: WHERE organization_id = p_organization_id
654: AND org_information_context = p_org_info_type_code;
655:
656: l_org_information1 hr_organization_information.org_information1%TYPE;
657: l_org_information2 hr_organization_information.org_information2%TYPE;
658:
659: BEGIN
660: g_debug:= hr_utility.debug_enabled;
661: l_procedure := g_package ||'check_stat_setup_df';