APPS.HR_ORGANIZATIONS_SV1 dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 19: org_organization_definitions table */

15: BEGIN
16: x_progress := '010';
17:
18: /* check to see if there are x_inv_organization_id exists in
19: org_organization_definitions table */
20:
21: SELECT count(*)
22: INTO x_temp
23: FROM org_organization_definitions

Line 23: FROM org_organization_definitions

19: org_organization_definitions table */
20:
21: SELECT count(*)
22: INTO x_temp
23: FROM org_organization_definitions
24: WHERE organization_id = x_inv_organization_id
25: AND sysdate < nvl(disable_date, sysdate+1)
26: AND inventory_enabled_flag = 'Y';
27:

Line 57: /* get the organization_id form org_organization_definitions

53: BEGIN
54:
55: X_progress := '010';
56:
57: /* get the organization_id form org_organization_definitions
58: table based on organization_code */
59:
60: SELECT organization_id
61: INTO X_organization_id_v

Line 62: FROM org_organization_definitions

58: table based on organization_code */
59:
60: SELECT organization_id
61: INTO X_organization_id_v
62: FROM org_organization_definitions
63: WHERE organization_code = X_organization_code
64: AND sysdate < nvl(disable_date, sysdate+1)
65: AND inventory_enabled_flag = 'Y';
66: