APPS.FUN_WEBADI_PKG dependencies on HZ_PARTIES

Line 653: From Hz_Parties Hzp, hz_party_usg_assignments hu

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

Line 718: From Hz_Parties hzp,

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