DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PVT dependencies on HR_OPERATING_UNITS

Line 31: SELECT 1 INTO l_count FROM HR_OPERATING_UNITS

27:
28: FUNCTION Validate_Operating_Unit(P_ORG_ID IN NUMBER) RETURN BOOLEAN IS
29: l_count NUMBER:=0;
30: BEGIN
31: SELECT 1 INTO l_count FROM HR_OPERATING_UNITS
32: WHERE ORGANIZATION_ID=P_ORG_ID
33: AND NVL(DATE_TO,SYSDATE) >= SYSDATE;
34: RETURN TRUE;
35: EXCEPTION

Line 1399: select name into from_org_name from hr_operating_units

1395: LOOP
1396: IF l_from_orgs_tab.exists(l_lines_table(l_index).from_org_id) THEN
1397: -- failure
1398: Begin
1399: select name into from_org_name from hr_operating_units
1400: where Organization_id=l_lines_table(l_index).from_org_id;
1401: Exception
1402: WHEN NO_DATA_FOUND THEN
1403: NULL;

Line 1417: select name into to_org_name from hr_operating_units

1413: --
1414: IF l_to_orgs_tab.exists(l_lines_table(l_index).from_org_id) THEN
1415: -- failure
1416: Begin
1417: select name into to_org_name from hr_operating_units
1418: where Organization_id=l_lines_table(l_index).to_org_id;
1419: Exception
1420: WHEN NO_DATA_FOUND THEN
1421: NULL;