DBA Data[Home] [Help]

APPS.GMS_BUDGET_UTILS dependencies on GMS_AWARDS

Line 1337: FROM gms_awards

1333: (p_award_id NUMBER)
1334: IS
1335: SELECT nvl(preaward_date,start_date_active), -- Added preaward_date for Bug:2266731
1336: end_date_active
1337: FROM gms_awards
1338: WHERE award_id = p_award_id;
1339:
1340: l_api_name CONSTANT VARCHAR2(30) := 'get_valid_period_dates';
1341: l_task_start_date DATE;

Line 1806: l_org_id gms_awards_all.org_id%TYPE := NULL;

1802: , x_err_code OUT NOCOPY NUMBER
1803: )
1804: IS
1805:
1806: l_org_id gms_awards_all.org_id%TYPE := NULL;
1807:
1808: Begin
1809: -- Assume Success
1810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1822: FROM gms_awards_all

1818: -- by the calling object.
1819:
1820: SELECT org_id
1821: INTO l_org_id
1822: FROM gms_awards_all
1823: WHERE award_id = p_award_id;
1824:
1825: -- Set the Operating Unit Context
1826: mo_global.set_policy_context(p_access_mode => 'S'