DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1451: FROM hr_all_organization_units

1447: l_procedure VARCHAR2(100);
1448:
1449: CURSOR csr_loc IS
1450: SELECT location_id
1451: FROM hr_all_organization_units
1452: WHERE organization_id = p_organization_id;
1453:
1454: l_location_id hr_all_organization_units.location_id%TYPE;
1455:

Line 1454: l_location_id hr_all_organization_units.location_id%TYPE;

1450: SELECT location_id
1451: FROM hr_all_organization_units
1452: WHERE organization_id = p_organization_id;
1453:
1454: l_location_id hr_all_organization_units.location_id%TYPE;
1455:
1456: BEGIN
1457: g_debug := hr_utility.debug_enabled;
1458: l_procedure := g_package ||'check_pf_location';

Line 1525: FROM hr_all_organization_units hou

1521: IS
1522: l_message VARCHAR2(255);
1523: CURSOR csr_state IS
1524: SELECT hl.loc_information16
1525: FROM hr_all_organization_units hou
1526: ,hr_locations hl
1527: WHERE hou.organization_id = p_organization_id
1528: AND hou.location_id = hl.location_id
1529: AND hl.style = 'IN';