APPS.CE_BANK_PUB dependencies on HZ_RELATIONSHIPS

Line 104: hz_relationships hz_rel,

100: hz_bankorg.bank_or_branch_number
101: FROM hz_parties hz_bank,
102: hz_organization_profiles hz_bankorg,
103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,
106: hz_code_assignments hz_branchCA
107: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
108: AND hz_branchCA.owner_table_id = hz_branch.party_id

Line 658: FROM hz_relationships

654: AND class_category = 'BANK_INSTITUTION_TYPE'
655: AND class_code = 'BANK';
656: CURSOR c_branch_id IS
657: SELECT subject_id
658: FROM hz_relationships
659: WHERE relationship_type = 'BANK_AND_BRANCH'
660: AND relationship_code = 'BRANCH_OF'
661: AND subject_table_name = 'HZ_PARTIES'
662: AND subject_type = 'ORGANIZATION'

Line 1619: FROM hz_relationships

1615: AND class_code = 'BANK';
1616:
1617: CURSOR c_bank_id IS
1618: SELECT object_id
1619: FROM hz_relationships
1620: WHERE relationship_type = 'BANK_AND_BRANCH'
1621: AND relationship_code = 'BRANCH_OF'
1622: AND subject_table_name = 'HZ_PARTIES'
1623: AND subject_type = 'ORGANIZATION'

Line 1934: hz_relationships hz_rel,

1930: CURSOR c_branch_name IS
1931: SELECT hz_branch.party_id,
1932: hz_branchCA.end_date_active
1933: FROM hz_parties hz_branch,
1934: hz_relationships hz_rel,
1935: hz_code_assignments hz_branchCA
1936: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1937: AND hz_branchCA.owner_table_id = hz_branch.party_id
1938: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 1957: hz_relationships hz_rel,

1953: SELECT hz_branch.party_id,
1954: hz_branchCA.end_date_active
1955: FROM hz_parties hz_branch,
1956: hz_organization_profiles hz_branchProf,
1957: hz_relationships hz_rel,
1958: hz_code_assignments hz_branchCA
1959: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1960: AND hz_branchCA.owner_table_id = hz_branch.party_id
1961: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 2064: FROM hz_relationships

2060: AND party_id = p_acct_rec.branch_id;
2061: /*
2062: CURSOR c_bank_id IS
2063: SELECT object_id
2064: FROM hz_relationships
2065: WHERE RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
2066: AND RELATIONSHIP_CODE = 'BRANCH_OF'
2067: AND subject_id = p_acct_rec.branch_id;
2068: */