APPS.ONT_OEXCEXP_XMLP_PKG dependencies on HZ_PARTIES

Line 282: HZ_PARTIES

278: DISTINCT
279: PARTY_NAME
280: INTO CP_PARTY_NAME
281: FROM
282: HZ_PARTIES
283: WHERE PARTY_ID = P_SPECIFIC_PARTY_ID;
284: ELSIF P_SPEC_PARTY_NUM_ID IS NOT NULL THEN
285: SELECT
286: DISTINCT

Line 290: HZ_PARTIES

286: DISTINCT
287: PARTY_NUMBER
288: INTO CP_PARTY_NUMBER
289: FROM
290: HZ_PARTIES
291: WHERE PARTY_ID = P_SPEC_PARTY_NUM_ID;
292: END IF;
293: RETURN (0);
294: END CF_GET_PARTY_NAMEFORMULA;

Line 338: HZ_PARTIES P

334: P.PARTY_NAME,
335: P.PARTY_NUMBER,
336: 0
337: FROM
338: HZ_PARTIES P
339: WHERE P.PARTY_ID = L_TOP_PARENT;
340: INSERT INTO OE_CREDIT_HIERARCHY_TEMP
341: (PARTY_ID
342: ,PARTY_PARENT_ID

Line 360: HZ_PARTIES

356: PARTY_NAME,
357: PARTY_NUMBER
358: INTO L_PARTY_NAME,L_PARTY_NUMBER
359: FROM
360: HZ_PARTIES
361: WHERE PARTY_ID = HIER_CSR_REC.PARTY_ID;
362: UPDATE
363: OE_CREDIT_HIERARCHY_TEMP
364: SET