DBA Data[Home] [Help]

APPS.IBY_EXTRACTGEN_PVT dependencies on PO_VENDORS

Line 556: ELSIF p_entity_table = G_DFF_PO_VENDORS THEN

552: INTO l_attribute_category
553: FROM IBY_EXT_BANK_ACCOUNTS
554: WHERE ext_bank_account_id = p_entity_id;
555:
556: ELSIF p_entity_table = G_DFF_PO_VENDORS THEN
557: l_num_of_attributes := 15;
558: l_from_clause := ' From ' || p_entity_table;
559: l_where_clause := ' Where VENDOR_ID = :p_entity_id ';
560: SELECT attribute_category

Line 562: FROM PO_VENDORS

558: l_from_clause := ' From ' || p_entity_table;
559: l_where_clause := ' Where VENDOR_ID = :p_entity_id ';
560: SELECT attribute_category
561: INTO l_attribute_category
562: FROM PO_VENDORS
563: WHERE VENDOR_ID = p_entity_id;
564:
565: ELSIF p_entity_table = G_DFF_PO_VENDOR_SITES THEN
566: l_num_of_attributes := 15;

Line 663: or p_entity_table = G_DFF_PO_VENDORS

659: or p_entity_table = G_DFF_LEGAL_ENTITY
660: or p_entity_table = G_DFF_PARTY
661: or p_entity_table = G_DFF_INT_BANK_ACCOUNT
662: or p_entity_table = G_DFF_EXT_BANK_ACCOUNT
663: or p_entity_table = G_DFF_PO_VENDORS
664: or p_entity_table = G_DFF_PO_VENDOR_SITES THEN
665: EXECUTE IMMEDIATE l_queryString INTO l_dffs using p_entity_id;
666: END IF;
667: END IF;