APPS.HZ_IMP_LOAD_PARTIES_PKG dependencies on HZ_IMP_PARTIES_SG

Line 642: from hz_imp_parties_sg p_sg

638: 'Y',
639: 'Y',
640: dup_val_exp_val,
641: other_exp_val
642: from hz_imp_parties_sg p_sg
643: where p_sg.action_flag = 'I'
644: and p_sg.batch_id = P_DML_RECORD.BATCH_ID
645: and p_sg.party_orig_system = P_DML_RECORD.OS
646: and p_sg.party_orig_system_reference

Line 2510: from hz_imp_parties_sg ps,

2506: then nullif(sicfi.class_code, :16)
2507: else null end sic_code,
2508: nvl2(nullif(nacfi.class_code, :16), 4, null) local_activity_code_type,
2509: nullif(nacfi.class_code, :16) local_activity_code
2510: from hz_imp_parties_sg ps,
2511: hz_imp_parties_int pi,
2512: hz_imp_addresses_sg ads,
2513: hz_imp_addresses_int adi,
2514: hz_imp_contactpts_sg webs,

Line 3229: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,

3225: p.status status,
3226: ps.party_id,
3227: ps.new_osr_exists_flag,
3228: ps.old_orig_system_reference
3229: FROM HZ_IMP_PARTIES_INT pi, HZ_IMP_PARTIES_SG ps, HZ_PARTIES p,
3230: HZ_PERSON_PROFILES pp,
3231: HZ_ORGANIZATION_PROFILES op,
3232: fnd_lookup_values party_type_l,
3233: fnd_lookup_values month_l,

Line 9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint

9442: FND_GLOBAL.User_ID CREATED_BY,
9443: SYSDATE LAST_UPDATE_DATE,
9444: FND_GLOBAL.User_ID LAST_UPDATED_BY,
9445: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
9446: FROM HZ_PARTIES party,HZ_IMP_PARTIES_SG ps, HZ_IMP_PARTIES_INT pint
9447: WHERE party.request_id = p_request_id
9448: AND party.party_id = ps.party_id
9449: AND ps.batch_mode_flag = p_batch_mode_flag
9450: AND ps.batch_id = p_batch_id