DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CREDITRATINGS_PKG dependencies on HZ_IMP_CREDITRTNGS_SG

Line 382: HZ_IMP_CREDITRTNGS_SG crsg,

378: decode(nvl(crint.insert_update_flag, crsg.action_flag), crsg.action_flag, ''Y'', null) action_mismatch_error,
379: crsg.error_flag
380: FROM
381: HZ_IMP_CREDITRTNGS_INT crint,
382: HZ_IMP_CREDITRTNGS_SG crsg,
383: fnd_lookup_values cr_l1,
384: fnd_lookup_values cr_l2,
385: fnd_lookup_values cr_l3,
386: fnd_lookup_values cr_l4,

Line 1334: hz_imp_creditrtngs_sg crsg,

1330: nvl2(cr_l23.lookup_code, ''Y'', null) cr_l23_code,
1331: nvl2(fc.CURRENCY_CODE, ''Y'', null) fc_code,
1332: nvl2(createdby_l.lookup_code, ''Y'', null) createdby_l
1333: from hz_imp_creditrtngs_int crint,
1334: hz_imp_creditrtngs_sg crsg,
1335: fnd_lookup_values cr_l1,
1336: fnd_lookup_values cr_l2,
1337: fnd_lookup_values cr_l3,
1338: fnd_lookup_values cr_l4,

Line 2292: from HZ_IMP_CREDITRTNGS_SG cr_sg

2288: 'Y', 'Y', 'Y',
2289: 'Y',
2290: 'Y',
2291: 'Y', 'Y'
2292: from HZ_IMP_CREDITRTNGS_SG cr_sg
2293: where cr_sg.action_flag = 'I'
2294: and cr_sg.batch_id = P_DML_RECORD.BATCH_ID
2295: and cr_sg.party_orig_system = P_DML_RECORD.OS
2296: and cr_sg.party_orig_system_reference