eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_VALIDATE_BANKINFO dependencies on HZ_PARTIES

Line 16: From HZ_PARTIES PartyBank,

12: BANK_ID_IS_NUM BOOLEAN := FALSE;
13:
14: cursor get_bank_num ( Xi_BANK_ID NUMBER) IS
15: select OrgProfileBank.BANK_OR_BRANCH_NUMBER
16: From HZ_PARTIES PartyBank,
17: HZ_ORGANIZATION_PROFILES OrgProfileBank,
18: HZ_CODE_ASSIGNMENTS CABank
19: Where
20: PartyBank.party_id = Xi_BANK_ID

Line 28: And CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'

24: and sysdate between trunc(OrgProfileBank.EFFECTIVE_START_DATE)
25: and nvl(trunc(OrgProfileBank.EFFECTIVE_END_DATE),sysdate)
26: And CABank.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
27: And CABank.CLASS_CODE = 'BANK'
28: And CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'
29: And CABank.OWNER_TABLE_ID = PartyBank.PARTY_ID
30: And nvl(CABank.status, 'A') = 'A';
31:
32:

Line 162: FROM HZ_PARTIES PartyBank,

158:
159: ELSE
160: -- Bank ID is being used. Check if Bank exists and fetch Bank Number --
161: SELECT count(*) INTO bank_count
162: FROM HZ_PARTIES PartyBank,
163: HZ_ORGANIZATION_PROFILES OrgProfileBank,
164: HZ_CODE_ASSIGNMENTS CABank
165: WHERE
166: PartyBank.party_id = Xi_BANK_ID

Line 174: AND CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'

170: AND sysdate BETWEEN trunc(OrgProfileBank.EFFECTIVE_START_DATE)
171: AND nvl(trunc(OrgProfileBank.EFFECTIVE_END_DATE),sysdate)
172: AND CABank.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
173: AND CABank.CLASS_CODE = 'BANK'
174: AND CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'
175: AND CABank.OWNER_TABLE_ID = PartyBank.PARTY_ID
176: AND nvl(CABank.status, 'A') = 'A';
177:
178:

Line 334: FROM HZ_PARTIES

330: ) RETURN VARCHAR2 IS
331:
332: CURSOR CHECK_UNIQUE_TAXID_BK IS -- Banks
333: SELECT JGZZ_FISCAL_CODE
334: FROM HZ_PARTIES
335: WHERE JGZZ_FISCAL_CODE = p_taxpayer_id
336: AND country = p_country_code;
337:
338: l_taxid VARCHAR2(30);

Line 417: -- replaced ra_customers with hz_parties

413: WHERE (AR.CUSTOMER_NAME=p_entity_name
414: OR AR.JGZZ_FISCAL_CODE= p_taxpayer_id)
415: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
416: */
417: -- replaced ra_customers with hz_parties
418:
419: CURSOR CHECK_CROSS_AR IS --Customers
420: SELECT AR.PARTY_NAME, AR.JGZZ_FISCAL_CODE
421: FROM HZ_PARTIES AR

Line 421: FROM HZ_PARTIES AR

417: -- replaced ra_customers with hz_parties
418:
419: CURSOR CHECK_CROSS_AR IS --Customers
420: SELECT AR.PARTY_NAME, AR.JGZZ_FISCAL_CODE
421: FROM HZ_PARTIES AR
422: WHERE (AR.PARTY_NAME=p_entity_name
423: OR AR.JGZZ_FISCAL_CODE= p_taxpayer_id)
424: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
425:

Line 669: From HZ_PARTIES BankParty,

665:
666: -- unique combination -> bank_id, branch_name, country --confirmed sql 6/25/02
667:
668: select count(*) into temp_name
669: From HZ_PARTIES BankParty,
670: HZ_PARTIES BranchParty,
671: HZ_ORGANIZATION_PROFILES BankOrgProfile,
672: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
673: HZ_RELATIONSHIPS BRRel,

Line 670: HZ_PARTIES BranchParty,

666: -- unique combination -> bank_id, branch_name, country --confirmed sql 6/25/02
667:
668: select count(*) into temp_name
669: From HZ_PARTIES BankParty,
670: HZ_PARTIES BranchParty,
671: HZ_ORGANIZATION_PROFILES BankOrgProfile,
672: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
673: HZ_RELATIONSHIPS BRRel,
674: HZ_CODE_ASSIGNMENTS BankCA,

Line 683: And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

679: And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
680: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
681: And BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
682: And BankCA.CLASS_CODE = 'BANK'
683: And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
684: And BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
685: And NVL(BankCA.STATUS, 'A') = 'A'
686: And BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
687: And BranchParty.status(+) = 'A'

Line 693: And BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

689: And SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
690: and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
691: And BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
692: And BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
693: And BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
694: And BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
695: And NVL(BranchCA.STATUS(+), 'A') = 'A'
696: And BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
697: And BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID

Line 701: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

697: And BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
698: And BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
699: And BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
700: And BRRel.STATUS(+) = 'A'
701: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
702: And BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
703: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
704: And BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
705: and BankParty.PARTY_ID = Xi_BANK_ID

Line 703: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

699: And BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
700: And BRRel.STATUS(+) = 'A'
701: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
702: And BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
703: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
704: And BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
705: and BankParty.PARTY_ID = Xi_BANK_ID
706: and BranchParty.party_name = Xi_BRANCH_NAME
707: and BranchParty.country = Xi_COUNTRY_NAME

Line 752: From HZ_PARTIES BankParty,

748:
749: -- unique combination -> bank_id, branch_number, country --confirmed sql 6/25/02
750:
751: select count(*) into temp_number
752: From HZ_PARTIES BankParty,
753: HZ_PARTIES BranchParty,
754: HZ_ORGANIZATION_PROFILES BankOrgProfile,
755: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
756: HZ_RELATIONSHIPS BRRel,

Line 753: HZ_PARTIES BranchParty,

749: -- unique combination -> bank_id, branch_number, country --confirmed sql 6/25/02
750:
751: select count(*) into temp_number
752: From HZ_PARTIES BankParty,
753: HZ_PARTIES BranchParty,
754: HZ_ORGANIZATION_PROFILES BankOrgProfile,
755: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
756: HZ_RELATIONSHIPS BRRel,
757: HZ_CODE_ASSIGNMENTS BankCA,

Line 766: And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

762: And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
763: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
764: And BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
765: And BankCA.CLASS_CODE = 'BANK'
766: And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
767: And BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
768: And NVL(BankCA.STATUS, 'A') = 'A'
769: And BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
770: And BranchParty.status(+) = 'A'

Line 776: And BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

772: And SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
773: and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
774: And BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
775: And BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
776: And BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
777: And BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
778: And NVL(BranchCA.STATUS(+), 'A') = 'A'
779: And BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
780: And BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID

Line 784: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

780: And BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
781: And BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
782: And BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
783: And BRRel.STATUS(+) = 'A'
784: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
785: And BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
786: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
787: And BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
788: and BankParty.PARTY_ID = Xi_BANK_ID

Line 786: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

782: And BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
783: And BRRel.STATUS(+) = 'A'
784: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
785: And BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
786: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
787: And BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
788: and BankParty.PARTY_ID = Xi_BANK_ID
789: and BranchOrgProfile.BANK_OR_BRANCH_NUMBER = Xi_BRANCH_NUMBER
790: and BranchParty.country = Xi_COUNTRY_NAME

Line 837: From HZ_PARTIES BankParty,

833:
834: -- unique combination -> bank_id, branch_name_alt, country bug 2363959 --confirmed sql 6/25/02
835:
836: select count(*) into temp_name_alt
837: From HZ_PARTIES BankParty,
838: HZ_PARTIES BranchParty,
839: HZ_ORGANIZATION_PROFILES BankOrgProfile,
840: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
841: HZ_RELATIONSHIPS BRRel,

Line 838: HZ_PARTIES BranchParty,

834: -- unique combination -> bank_id, branch_name_alt, country bug 2363959 --confirmed sql 6/25/02
835:
836: select count(*) into temp_name_alt
837: From HZ_PARTIES BankParty,
838: HZ_PARTIES BranchParty,
839: HZ_ORGANIZATION_PROFILES BankOrgProfile,
840: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
841: HZ_RELATIONSHIPS BRRel,
842: HZ_CODE_ASSIGNMENTS BankCA,

Line 851: And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

847: And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
848: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
849: And BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
850: And BankCA.CLASS_CODE = 'BANK'
851: And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
852: And BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
853: And NVL(BankCA.STATUS, 'A') = 'A'
854: And BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
855: And BranchParty.status(+) = 'A'

Line 861: And BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

857: And SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
858: and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
859: And BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
860: And BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
861: And BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
862: And BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
863: And NVL(BranchCA.STATUS(+), 'A') = 'A'
864: And BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
865: And BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID

Line 869: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

865: And BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
866: And BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
867: And BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
868: And BRRel.STATUS(+) = 'A'
869: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
870: And BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
871: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
872: And BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
873: and BankParty.PARTY_ID = Xi_BANK_ID

Line 871: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

867: And BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
868: And BRRel.STATUS(+) = 'A'
869: And BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
870: And BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
871: And BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
872: And BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
873: and BankParty.PARTY_ID = Xi_BANK_ID
874: and BranchParty.ORGANIZATION_NAME_PHONETIC = Xi_BRANCH_NAME_ALT
875: and BranchParty.country = Xi_COUNTRY_NAME

Line 7580: From HZ_PARTIES HzPartyBankEO,

7576:
7577: -- unique combination -> bank_name_alt, country bug 2363959 --confirmed sql 6/28/02
7578:
7579: select count(*) into temp_name_alt
7580: From HZ_PARTIES HzPartyBankEO,
7581: HZ_ORGANIZATION_PROFILES HzOrgProfileBankEO,
7582: HZ_CODE_ASSIGNMENTS HzCodeAssignmentBankEO
7583: Where
7584: HzPartyBankEO.ORGANIZATION_NAME_PHONETIC = Xi_BANK_NAME_ALT

Line 7593: And HzCodeAssignmentBankEO.OWNER_TABLE_NAME = 'HZ_PARTIES'

7589: and sysdate between trunc(HzOrgProfileBankEO.EFFECTIVE_START_DATE)
7590: and nvl(trunc(HzOrgProfileBankEO.EFFECTIVE_END_DATE),sysdate)
7591: And HzCodeAssignmentBankEO.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
7592: And HzCodeAssignmentBankEO.CLASS_CODE = 'BANK'
7593: And HzCodeAssignmentBankEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
7594: And HzCodeAssignmentBankEO.OWNER_TABLE_ID = HzPartyBankEO.PARTY_ID
7595: And nvl(HzCodeAssignmentBankEO.status, 'A') = 'A'
7596: And HzPartyBankEO.PARTY_ID = nvl(Xi_BANK_ID, -1);
7597: