APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_RELATIONSHIPS

Line 572: FROM hz_imp_parties_sg ps,hz_imp_relships_sg rs,hz_relationships r

568: ) IS
569:
570: CURSOR c_party IS
571: SELECT r.object_id,r.subject_id, r.relationship_code
572: FROM hz_imp_parties_sg ps,hz_imp_relships_sg rs,hz_relationships r
573: WHERE ps.batch_id = p_batch_id
574: AND ps.batch_mode_flag = p_batch_mode_flag
575: AND ps.party_orig_system_reference BETWEEN p_from_osr AND p_to_osr
576: AND ps.party_orig_system = 'DNB'

Line 1295: /* HZ_RELATIONSHIPS */

1291:
1292: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1293: END IF;
1294:
1295: /* HZ_RELATIONSHIPS */
1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1297: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1298: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');

Line 1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');

1292: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1293: END IF;
1294:
1295: /* HZ_RELATIONSHIPS */
1296: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1297: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1298: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);
1299: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1300:

Line 1402: /* HZ_RELATIONSHIPS */

1398:
1399: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1400: END IF;
1401:
1402: /* HZ_RELATIONSHIPS */
1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1404: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1405: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');

Line 1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');

1399: fnd_file.put_line(fnd_file.log,' Generate Customer Key (-) ');
1400: END IF;
1401:
1402: /* HZ_RELATIONSHIPS */
1403: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_RELATIONSHIPS entity ');
1404: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (+) ');
1405: pp_denorm_rel(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');
1406: fnd_file.put_line(fnd_file.log,' Relationship Denormalization (-) ');
1407: