APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HZ_PARTIES

Line 102: FROM hz_parties BankParty,

98: -- of combination of name-number-country. Commented out cursors
99: -- which were not needed.
100: CURSOR c_bank_name_number_uk IS
101: SELECT 'Y'
102: FROM hz_parties BankParty,
103: hz_organization_profiles BankOrgProfile,
104: hz_code_assignments BankCA
105: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
106: AND BankParty.status = 'A'

Line 112: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

108: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
109: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
110: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
111: AND BankCA.CLASS_CODE = 'BANK'
112: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
113: AND NVL(BankCA.STATUS, 'A') = 'A'
114: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
115: AND BankOrgProfile.home_country = l_country
116: AND nvl(BankOrgProfile.bank_or_branch_number,'--NULL--') = nvl(l_bank_number,'--NULL--')

Line 128: FROM hz_parties BankParty,

124: WHERE temp_id = p_temp_id;
125: */
126: /* CURSOR c_bank_name_uk IS
127: SELECT 'Y'
128: FROM hz_parties BankParty,
129: hz_code_assignments BankCA,
130: hz_organization_profiles BankOrgProfile
131: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
132: AND BankParty.status = 'A'

Line 138: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

134: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
135: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
136: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
137: AND BankCA.CLASS_CODE = 'BANK'
138: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
139: AND NVL(BankCA.STATUS, 'A') = 'A'
140: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
141: AND BankOrgProfile.home_country = l_country
142: AND upper(BankParty.party_name) = upper(l_bank_name)

Line 147: FROM hz_parties BankParty,

143: AND BankParty.party_id <> p_temp_id;*/
144: /*
145: CURSOR c_short_name_uk IS
146: SELECT 'Y'
147: FROM hz_parties BankParty,
148: hz_code_assignments BankCA,
149: hz_organization_profiles BankOrgProfile
150: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
151: AND BankParty.status = 'A'

Line 157: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

153: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
154: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
155: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
156: AND BankCA.CLASS_CODE = 'BANK'
157: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
158: AND NVL(BankCA.STATUS, 'A') = 'A'
159: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
160: AND BankOrgProfile.home_country = l_country
161: AND BankParty.known_as = l_short_name

Line 166: FROM hz_parties BankParty,

162: AND BankParty.party_id <> p_temp_id;
163: */
164: /* CURSOR c_bank_number_uk IS
165: SELECT 'Y'
166: FROM hz_parties BankParty,
167: hz_organization_profiles BankOrgProfile,
168: hz_code_assignments BankCA
169: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
170: AND BankParty.status = 'A'

Line 176: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

172: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
173: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
174: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
175: AND BankCA.CLASS_CODE = 'BANK'
176: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
177: AND NVL(BankCA.STATUS, 'A') = 'A'
178: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
179: AND BankOrgProfile.home_country = l_country
180: AND BankOrgProfile.bank_or_branch_number = l_bank_number