DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on HZ_PARTIES

Line 652: From Hz_Parties Hzp, hz_party_usg_assignments hu

648: -- Bug No: 6134848. 2 more condetions added to validate Party_usage_code.
649:
650: Cursor C_Party(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is
651: Select hzp.party_id
652: From Hz_Parties Hzp, hz_party_usg_assignments hu
653: Where hzp.party_type = 'ORGANIZATION'
654: And hzp.party_name = cp_party_name
655: And hzp.party_id = hu.party_id
656: And hu.party_usage_code = 'INTERCOMPANY_ORG';

Line 717: From Hz_Parties hzp,

713: From dual;
714:
715: Cursor C_Ccid(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is
716: Select chart_of_accounts_id
717: From Hz_Parties hzp,
718: xle_firstparty_information_v xfi ,
719: Gl_Ledger_Le_V led
720: Where hzp.party_name = cp_party_name
721: And fun_tca_pkg.get_le_id(hzp.party_id) = xfi.party_id