APPS.PON_UDA_IMPORT_PKG dependencies on PO_UDA_AG_TEMPLATES

Line 365: po_uda_ag_templates t,

361: INTO l_desc_flex_cntxt_name, l_database_col
362: FROM FND_DESCR_FLEX_CONTEXTS_tl agtl,
363: FND_DESCR_FLEX_CONTEXTS ag,
364: EGO_ATTRS_V attr,
365: po_uda_ag_templates t,
366: po_uda_ag_template_usages u,
367: ego_fnd_dsc_flx_ctx_ext egoag
368: WHERE attr.ATTR_GROUP_TYPE = ag.DESCRIPTIVE_FLEXFIELD_NAME
369: AND attr.ATTR_GROUP_NAME = ag.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 541: FROM po_uda_ag_templates

537: WHERE DESCRIPTIVE_FLEXFIELD_NAME = l_attr_group_type AND
538: DESCRIPTIVE_FLEX_CONTEXT_CODE = l_attr_group_name;
539:
540: SELECT TEMPLATE_ID INTO l_uda_template_id
541: FROM po_uda_ag_templates
542: WHERE FUNCTIONAL_AREA='SOURCING' AND
543: ENTITY_CODE=l_attr_group_type;
544:
545: SELECT ATTRIBUTE_CATEGORY INTO l_attr_category