[Home] [Help]
424: l_object_version_number NUMBER;
425:
426: CURSOR c_bank_ovn IS
427: SELECT object_version_number
428: FROM hz_parties
429: WHERE party_id = p_bank_id;
430:
431: BEGIN
432:
829: CURSOR c_rfc_identifier_ovn(p_branch_id NUMBER) IS
830: SELECT object_version_number
831: FROM HZ_CODE_ASSIGNMENTS
832: WHERE class_category = 'RFC_IDENTIFIER'
833: AND owner_table_name = 'HZ_PARTIES'
834: AND owner_table_id = p_branch_id;
835:
836: -- Picks up object version number of EFT Record
837: CURSOR c_eft_record_ovn(p_branch_id NUMBER) IS
837: CURSOR c_eft_record_ovn(p_branch_id NUMBER) IS
838: SELECT object_version_number
839: FROM HZ_CODE_ASSIGNMENTS
840: WHERE class_category = 'EFT'
841: AND owner_table_name = 'HZ_PARTIES'
842: AND owner_table_id = p_branch_id;
843:
844: BEGIN
845: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1057: l_object_version_number NUMBER;
1058:
1059: CURSOR c_branch_party_ovn IS
1060: SELECT object_version_number
1061: FROM hz_parties
1062: WHERE party_id = p_branch_id;
1063:
1064: BEGIN
1065:
4688: x_return_status IN OUT NOCOPY VARCHAR2
4689: ) RETURN VARCHAR2 IS
4690: CURSOR c_country IS
4691: SELECT hp.country
4692: FROM hz_parties hp
4693: WHERE hp.party_id = p_bank_id
4694: AND hp.status = 'A';
4695: l_country VARCHAR2(60);
4696: BEGIN
4746: SELECT hz_bank.party_id AS bank_id,
4747: hz_bank.country,
4748: hz_bank.party_name,
4749: hz_bankorg.bank_or_branch_number
4750: FROM hz_parties hz_bank,
4751: hz_organization_profiles hz_bankorg,
4752: hz_parties hz_branch,
4753: hz_relationships hz_rel,
4754: hz_code_assignments hz_bankCA,
4748: hz_bank.party_name,
4749: hz_bankorg.bank_or_branch_number
4750: FROM hz_parties hz_bank,
4751: hz_organization_profiles hz_bankorg,
4752: hz_parties hz_branch,
4753: hz_relationships hz_rel,
4754: hz_code_assignments hz_bankCA,
4755: hz_code_assignments hz_branchCA
4756: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
4752: hz_parties hz_branch,
4753: hz_relationships hz_rel,
4754: hz_code_assignments hz_bankCA,
4755: hz_code_assignments hz_branchCA
4756: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
4757: AND hz_branchCA.owner_table_id = hz_branch.party_id
4758: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
4759: AND hz_branchCA.class_code = 'BANK_BRANCH'
4760: AND NVL(hz_branchCA.STATUS, 'A') = 'A'
4759: AND hz_branchCA.class_code = 'BANK_BRANCH'
4760: AND NVL(hz_branchCA.STATUS, 'A') = 'A'
4761: AND hz_bankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
4762: AND hz_bankCA.CLASS_CODE = 'BANK'
4763: AND hz_bankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
4764: AND hz_bankCA.OWNER_TABLE_ID = hz_bank.PARTY_ID
4765: AND NVL(hz_bankCA.STATUS, 'A') = 'A'
4766: AND hz_rel.OBJECT_ID = hz_bank.PARTY_ID
4767: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
4767: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
4768: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
4769: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
4770: And hz_rel.STATUS = 'A'
4771: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4772: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
4773: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4774: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
4775: AND hz_bank.party_id = hz_bankorg.party_id
4769: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
4770: And hz_rel.STATUS = 'A'
4771: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4772: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
4773: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4774: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
4775: AND hz_bank.party_id = hz_bankorg.party_id
4776: AND SYSDATE between TRUNC(hz_bankorg.effective_start_date)
4777: and NVL(TRUNC(hz_bankorg.effective_end_date), SYSDATE+1)