APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 1754: --performance fix : changed to get_ledger_id (LE Uptake) to get it from hr_organization_information

1750: dl.delivery_id = dg.delivery_id AND
1751: dg.pick_up_stop_id = st.stop_id AND
1752: st.trip_id = t.trip_id;
1753:
1754: --performance fix : changed to get_ledger_id (LE Uptake) to get it from hr_organization_information
1755: --instead of org_organization_definitions
1756: CURSOR get_ledger_id (l_org_id NUMBER) IS
1757: SELECT hoi.org_information1 ledger_id
1758: from hr_organization_information hoi

Line 1758: from hr_organization_information hoi

1754: --performance fix : changed to get_ledger_id (LE Uptake) to get it from hr_organization_information
1755: --instead of org_organization_definitions
1756: CURSOR get_ledger_id (l_org_id NUMBER) IS
1757: SELECT hoi.org_information1 ledger_id
1758: from hr_organization_information hoi
1759: WHERE hoi.organization_id = l_org_id
1760: AND hoi.org_information_context = 'Accounting Information';
1761:
1762: --

Line 1978: --performance fix : changed to get ledger_id to get it from hr_organization_information

1974: FROM wsh_packing_slips_db_v
1975: WHERE delivery_id = p_delivery_id;
1976:
1977: --LE Uptake
1978: --performance fix : changed to get ledger_id to get it from hr_organization_information
1979: --instead of org_organization_definitions
1980: CURSOR get_ledger_id (l_org_id NUMBER) IS
1981: SELECT hoi.org_information1 ledger_id
1982: from hr_organization_information hoi

Line 1982: from hr_organization_information hoi

1978: --performance fix : changed to get ledger_id to get it from hr_organization_information
1979: --instead of org_organization_definitions
1980: CURSOR get_ledger_id (l_org_id NUMBER) IS
1981: SELECT hoi.org_information1 ledger_id
1982: from hr_organization_information hoi
1983: WHERE hoi.organization_id = l_org_id
1984: AND hoi.org_information_context = 'Accounting Information';
1985:
1986: l_ledger_id NUMBER;