DBA Data[Home] [Help]

APPS.POA_GA_UTIL_PKG dependencies on PO_GA_ORG_ASSIGNMENTS

Line 8: l_enabled_flag PO_GA_ORG_ASSIGNMENTS.enabled_flag%TYPE;

4: FUNCTION is_enabled(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
5: p_org_id IN PO_HEADERS_ALL.org_id%TYPE)
6: RETURN VARCHAR2 IS
7:
8: l_enabled_flag PO_GA_ORG_ASSIGNMENTS.enabled_flag%TYPE;
9:
10: BEGIN
11:
12: SELECT pgoa.enabled_flag

Line 14: FROM po_ga_org_assignments pgoa

10: BEGIN
11:
12: SELECT pgoa.enabled_flag
13: INTO l_enabled_flag
14: FROM po_ga_org_assignments pgoa
15: WHERE pgoa.po_header_id = p_po_header_id -- input global agreement id
16: AND pgoa.organization_id = p_org_id; -- input org id
17:
18: return l_enabled_flag;