DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_DOCS_PAYABLE_ALL

Line 645: FROM IBY_DOCS_PAYABLE_ALL

641: l_from_clause := ' From ' || p_entity_table;
642: l_where_clause := ' Where document_payable_id = :p_entity_id ';
643: SELECT attribute_category
644: INTO l_attribute_category
645: FROM IBY_DOCS_PAYABLE_ALL
646: WHERE document_payable_id = p_entity_id;
647: ELSE
648: RETURN NULL;
649: END IF;

Line 751: FROM iby_docs_payable_all idp

747: print_debuginfo (l_debug_module, 'Before Execution the query for the table:'||G_DFF_AP_DOC);
748:
749: SELECT attribute_category
750: INTO l_attribute_category
751: FROM iby_docs_payable_all idp
752: WHERE idp.document_payable_id = p_entity_id;
753:
754: IF(l_attribute_category IS NULL) THEN
755: Select XMLConcat(XMLElement("AttributeCategory", attribute_category),

Line 765: From iby_docs_payable_all idp

761: XMLElement("Attribute11", attribute11), XMLElement("Attribute12", attribute12),
762: XMLElement("Attribute13", attribute13), XMLElement("Attribute14", attribute14),
763: XMLElement("Attribute15", attribute15))
764: INTO l_dffs
765: From iby_docs_payable_all idp
766: WHERE idp.document_payable_id = p_entity_id;
767:
768: ELSE
769: Select XMLConcat(XMLElement("AttributeCategory", attribute_category),

Line 786: From iby_docs_payable_all idp

782: XMLElement("Attribute13", TRANSLATE(attribute13,l_conc_invalid_chars,l_conc_replacement_chars)),
783: XMLElement("Attribute14", TRANSLATE(attribute14,l_conc_invalid_chars,l_conc_replacement_chars)),
784: XMLElement("Attribute15", TRANSLATE(attribute15,l_conc_invalid_chars,l_conc_replacement_chars)))
785: INTO l_dffs
786: From iby_docs_payable_all idp
787: WHERE idp.document_payable_id = p_entity_id;
788: END IF;
789: print_debuginfo (l_debug_module, 'After Execution the query for the table: '||G_DFF_AP_DOC);
790: ELSE