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 10: FROM HZ_PARTIES PartyBank,

6: BANK_ID_IS_NUM BOOLEAN := FALSE;
7:
8: CURSOR get_bank_num (Xi_BANK_ID NUMBER) IS
9: SELECT OrgProfileBank.BANK_OR_BRANCH_NUMBER
10: FROM HZ_PARTIES PartyBank,
11: HZ_ORGANIZATION_PROFILES OrgProfileBank,
12: HZ_CODE_ASSIGNMENTS CABank
13: WHERE
14: PartyBank.party_id = Xi_BANK_ID

Line 22: AND CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'

18: AND SYSDATE BETWEEN TRUNC(OrgProfileBank.EFFECTIVE_START_DATE)
19: AND NVL(TRUNC(OrgProfileBank.EFFECTIVE_END_DATE),SYSDATE)
20: AND CABank.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
21: AND CABank.CLASS_CODE = 'BANK'
22: AND CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'
23: AND CABank.OWNER_TABLE_ID = PartyBank.PARTY_ID
24: AND NVL(CABank.status, 'A') = 'A';
25:
26: ---Bug 15958504 added procedure for branch end_date check

Line 189: FROM HZ_PARTIES PartyBank,

185:
186: ELSE
187: -- Bank ID is being used. Check if Bank exists and fetch Bank Number --
188: SELECT count(*) INTO bank_count
189: FROM HZ_PARTIES PartyBank,
190: HZ_ORGANIZATION_PROFILES OrgProfileBank,
191: HZ_CODE_ASSIGNMENTS CABank
192: WHERE
193: PartyBank.party_id = Xi_BANK_ID

Line 201: AND CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'

197: AND sysdate BETWEEN trunc(OrgProfileBank.EFFECTIVE_START_DATE)
198: AND nvl(trunc(OrgProfileBank.EFFECTIVE_END_DATE),sysdate)
199: AND CABank.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
200: AND CABank.CLASS_CODE = 'BANK'
201: AND CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'
202: AND CABank.OWNER_TABLE_ID = PartyBank.PARTY_ID
203: AND nvl(CABank.status, 'A') = 'A';
204:
205:

Line 395: -- replaced ra_customers with hz_parties

391: WHERE (AP.VENDOR_NAME=p_entity_name OR AP.NUM_1099= p_taxpayer_id)
392: AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
393:
394: -- Customers
395: -- replaced ra_customers with hz_parties
396: CURSOR CHECK_CROSS_AR IS
397: SELECT AR.PARTY_NAME, AR.JGZZ_FISCAL_CODE
398: FROM HZ_PARTIES AR
399: WHERE (AR.PARTY_NAME=p_entity_name OR AR.JGZZ_FISCAL_CODE= p_taxpayer_id)

Line 398: FROM HZ_PARTIES AR

394: -- Customers
395: -- replaced ra_customers with hz_parties
396: CURSOR CHECK_CROSS_AR IS
397: SELECT AR.PARTY_NAME, AR.JGZZ_FISCAL_CODE
398: FROM HZ_PARTIES AR
399: WHERE (AR.PARTY_NAME=p_entity_name OR AR.JGZZ_FISCAL_CODE= p_taxpayer_id)
400: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
401:
402: -- Companies

Line 592: FROM HZ_PARTIES BankParty,

588: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_UNIQUE_BRANCH_NAME');
589:
590: -- unique combination -> bank_id, branch_name, country --confirmed sql 6/25/02
591: SELECT COUNT(*) INTO temp_name
592: FROM HZ_PARTIES BankParty,
593: HZ_PARTIES BranchParty,
594: HZ_ORGANIZATION_PROFILES BankOrgProfile,
595: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
596: HZ_RELATIONSHIPS BRRel,

Line 593: HZ_PARTIES BranchParty,

589:
590: -- unique combination -> bank_id, branch_name, country --confirmed sql 6/25/02
591: SELECT COUNT(*) INTO temp_name
592: FROM HZ_PARTIES BankParty,
593: HZ_PARTIES BranchParty,
594: HZ_ORGANIZATION_PROFILES BankOrgProfile,
595: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
596: HZ_RELATIONSHIPS BRRel,
597: HZ_CODE_ASSIGNMENTS BankCA,

Line 606: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

602: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
603: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
604: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
605: AND BankCA.CLASS_CODE = 'BANK'
606: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
607: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
608: AND NVL(BankCA.STATUS, 'A') = 'A'
609: AND BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
610: AND BranchParty.status(+) = 'A'

Line 616: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

612: AND SYSDATE BETWEEN TRUNC(BranchOrgProfile.effective_start_date(+))
613: AND NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
614: AND BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
615: AND BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
616: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
617: AND BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
618: AND NVL(BranchCA.STATUS(+), 'A') = 'A'
619: AND BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
620: AND BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID

Line 624: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

620: AND BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
621: AND BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
622: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
623: AND BRRel.STATUS(+) = 'A'
624: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
625: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
626: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
627: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
628: AND BankParty.PARTY_ID = Xi_BANK_ID

Line 626: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

622: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
623: AND BRRel.STATUS(+) = 'A'
624: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
625: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
626: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
627: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
628: AND BankParty.PARTY_ID = Xi_BANK_ID
629: AND BranchParty.party_name = Xi_BRANCH_NAME
630: /* Bug 13641238: country is stored in OrgProfile

Line 670: FROM HZ_PARTIES BankParty,

666:
667: -- unique combination -> bank_id, branch_number, country --confirmed sql 6/25/02
668:
669: SELECT COUNT(*) INTO temp_number
670: FROM HZ_PARTIES BankParty,
671: HZ_PARTIES BranchParty,
672: HZ_ORGANIZATION_PROFILES BankOrgProfile,
673: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
674: HZ_RELATIONSHIPS BRRel,

Line 671: HZ_PARTIES BranchParty,

667: -- unique combination -> bank_id, branch_number, country --confirmed sql 6/25/02
668:
669: SELECT COUNT(*) INTO temp_number
670: FROM HZ_PARTIES BankParty,
671: HZ_PARTIES BranchParty,
672: HZ_ORGANIZATION_PROFILES BankOrgProfile,
673: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
674: HZ_RELATIONSHIPS BRRel,
675: HZ_CODE_ASSIGNMENTS BankCA,

Line 684: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

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

Line 694: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

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

Line 702: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

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

Line 704: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

700: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
701: AND BRRel.STATUS(+) = 'A'
702: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
703: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
704: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
705: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
706: AND BankParty.PARTY_ID = Xi_BANK_ID
707: AND BranchOrgProfile.BANK_OR_BRANCH_NUMBER = Xi_BRANCH_NUMBER
708: /* Bug 13641238: country is stored in OrgProfile

Line 746: FROM HZ_PARTIES BankParty,

742: -- unique combination -> bank_id, branch_name_alt, country bug 2363959
743: -- confirmed sql 6/25/02
744:
745: SELECT COUNT(*) INTO temp_name_alt
746: FROM HZ_PARTIES BankParty,
747: HZ_PARTIES BranchParty,
748: HZ_ORGANIZATION_PROFILES BankOrgProfile,
749: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
750: HZ_RELATIONSHIPS BRRel,

Line 747: HZ_PARTIES BranchParty,

743: -- confirmed sql 6/25/02
744:
745: SELECT COUNT(*) INTO temp_name_alt
746: FROM HZ_PARTIES BankParty,
747: HZ_PARTIES BranchParty,
748: HZ_ORGANIZATION_PROFILES BankOrgProfile,
749: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
750: HZ_RELATIONSHIPS BRRel,
751: HZ_CODE_ASSIGNMENTS BankCA,

Line 760: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

756: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
757: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
758: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
759: AND BankCA.CLASS_CODE = 'BANK'
760: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
761: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
762: AND NVL(BankCA.STATUS, 'A') = 'A'
763: AND BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
764: AND BranchParty.status(+) = 'A'

Line 770: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

766: AND SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
767: and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
768: AND BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
769: AND BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
770: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
771: AND BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
772: AND NVL(BranchCA.STATUS(+), 'A') = 'A'
773: AND BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
774: AND BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID

Line 778: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

774: AND BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
775: AND BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
776: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
777: AND BRRel.STATUS(+) = 'A'
778: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
779: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
780: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
781: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
782: AND BankParty.PARTY_ID = Xi_BANK_ID

Line 780: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

776: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
777: AND BRRel.STATUS(+) = 'A'
778: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
779: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
780: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
781: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
782: AND BankParty.PARTY_ID = Xi_BANK_ID
783: AND BranchParty.ORGANIZATION_NAME_PHONETIC = Xi_BRANCH_NAME_ALT
784: AND BranchOrgProfile.home_country = Xi_COUNTRY_NAME -- bug 8552410 Changed BranchParty to BranchOrgProfile

Line 6486: FROM HZ_PARTIES BankParty,

6482: BEGIN
6483: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_UNIQUE_BRANCH');
6484: SELECT COUNT(*)
6485: INTO l_temp_number
6486: FROM HZ_PARTIES BankParty,
6487: HZ_PARTIES BranchParty,
6488: HZ_ORGANIZATION_PROFILES BankOrgProfile,
6489: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
6490: HZ_RELATIONSHIPS BRRel,

Line 6487: HZ_PARTIES BranchParty,

6483: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_UNIQUE_BRANCH');
6484: SELECT COUNT(*)
6485: INTO l_temp_number
6486: FROM HZ_PARTIES BankParty,
6487: HZ_PARTIES BranchParty,
6488: HZ_ORGANIZATION_PROFILES BankOrgProfile,
6489: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
6490: HZ_RELATIONSHIPS BRRel,
6491: HZ_CODE_ASSIGNMENTS BankCA,

Line 6500: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

6496: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
6497: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
6498: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
6499: AND BankCA.CLASS_CODE = 'BANK'
6500: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
6501: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
6502: AND NVL(BankCA.STATUS, 'A') = 'A'
6503: AND BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
6504: AND BranchParty.status(+) = 'A'

Line 6510: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

6506: AND SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
6507: and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
6508: AND BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
6509: AND BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
6510: AND BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
6511: AND BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
6512: AND NVL(BranchCA.STATUS(+), 'A') = 'A'
6513: AND BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
6514: AND BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID

Line 6518: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

6514: AND BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
6515: AND BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
6516: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
6517: AND BRRel.STATUS(+) = 'A'
6518: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
6519: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
6520: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
6521: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
6522: AND BankParty.PARTY_ID = Xi_BANK_ID

Line 6520: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

6516: AND BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
6517: AND BRRel.STATUS(+) = 'A'
6518: AND BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
6519: AND BRRel.SUBJECT_TYPE(+) = 'ORGANIZATION'
6520: AND BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
6521: AND BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
6522: AND BankParty.PARTY_ID = Xi_BANK_ID
6523: AND BranchParty.PARTY_NAME = Xi_BRANCH_NAME
6524: AND nvl(BranchOrgProfile.BANK_OR_BRANCH_NUMBER,'X') = nvl(Xi_BRANCH_NUMBER,'X')

Line 6608: FROM HZ_PARTIES HzPartyBankEO,

6604: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_UNIQUE_BANK_JP');
6605: -- unique combination -> bank_name_alt, country bug 2363959 --confirmed sql 6/28/02
6606: SELECT COUNT(*)
6607: INTO temp_name_alt
6608: FROM HZ_PARTIES HzPartyBankEO,
6609: HZ_ORGANIZATION_PROFILES HzOrgProfileBankEO,
6610: HZ_CODE_ASSIGNMENTS HzCodeAssignmentBankEO
6611: WHERE HzPartyBankEO.ORGANIZATION_NAME_PHONETIC = Xi_BANK_NAME_ALT
6612: AND HzOrgProfileBankEO.home_country = Xi_COUNTRY_NAME -- 8552410: Changed HzPartyBankEO to HzOrgProfileBankEO

Line 6620: AND HzCodeAssignmentBankEO.OWNER_TABLE_NAME = 'HZ_PARTIES'

6616: AND SYSDATE BETWEEN TRUNC(HzOrgProfileBankEO.EFFECTIVE_START_DATE)
6617: AND NVL(TRUNC(HzOrgProfileBankEO.EFFECTIVE_END_DATE),SYSDATE)
6618: AND HzCodeAssignmentBankEO.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
6619: AND HzCodeAssignmentBankEO.CLASS_CODE = 'BANK'
6620: AND HzCodeAssignmentBankEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
6621: AND HzCodeAssignmentBankEO.OWNER_TABLE_ID = HzPartyBankEO.PARTY_ID
6622: AND NVL(HzCodeAssignmentBankEO.status, 'A') = 'A'
6623: AND HzPartyBankEO.PARTY_ID <> NVL(Xi_BANK_ID, -1); -- Bug 8552410: Changed = to <>
6624: