APPS.FUN_TCA_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 158: FROM hz_party_usg_assignments hua

154: END IF;
155:
156: SELECT status_flag
157: INTO l_status
158: FROM hz_party_usg_assignments hua
159: WHERE hua.party_id = p_party_id
160: AND hua.party_usage_code = 'INTERCOMPANY_ORG';
161: /*
162: SELECT status

Line 195: FROM hz_party_usg_assignments hua

191: END IF;
192:
193: SELECT status_flag
194: INTO l_status
195: FROM hz_party_usg_assignments hua
196: WHERE hua.party_id = p_party_id
197: AND hua.party_usage_code = 'INTERCOMPANY_ORG'
198: AND hua.effective_start_date <= NVL(p_as_date, sysdate)
199: AND (hua.effective_end_date >= NVL(p_as_date, sysdate) OR effective_end_date IS NULL);

Line 226: FROM hz_party_usg_assignments hua

222: PROCEDURE get_ic_org_valid_dates (p_party_id IN NUMBER, effective_start_date OUT NOCOPY DATE, effective_end_date OUT NOCOPY DATE)
223: is
224: CURSOR ic_valid_dates IS
225: SELECT hua.effective_start_date, hua.effective_end_date
226: FROM hz_party_usg_assignments hua
227: WHERE hua.party_id = p_party_id
228: AND hua.party_usage_code = 'INTERCOMPANY_ORG'
229: AND hua.effective_start_date = (
230: SELECT max(effective_start_date)

Line 231: FROM hz_party_usg_assignments

227: WHERE hua.party_id = p_party_id
228: AND hua.party_usage_code = 'INTERCOMPANY_ORG'
229: AND hua.effective_start_date = (
230: SELECT max(effective_start_date)
231: FROM hz_party_usg_assignments
232: WHERE party_id = p_party_id
233: AND party_usage_code = 'INTERCOMPANY_ORG'
234: );
235: BEGIN

Line 307: FROM hz_parties h, hz_party_usg_assignments hua

303: IS
304:
305: CURSOR chk_party IS
306: SELECT 'Y'
307: FROM hz_parties h, hz_party_usg_assignments hua
308: WHERE h.party_name = l_party_name
309: AND hua.party_id = h.party_id
310: AND hua.party_usage_code = 'INTERCOMPANY_ORG';
311: BEGIN