APPS.HZ_PARTY_MERGE dependencies on HZ_CREDIT_RATINGS

Line 3977: -- Handle DNB data in HZ_CREDIT_RATINGS

3973: END;
3974: END LOOP;
3975:
3976: -- *******************************************
3977: -- Handle DNB data in HZ_CREDIT_RATINGS
3978: FOR FROM_CR IN (
3979: SELECT credit_rating_id, rated_as_of_date
3980: FROM HZ_CREDIT_RATINGS
3981: WHERE actual_content_source = 'DNB'

Line 3980: FROM HZ_CREDIT_RATINGS

3976: -- *******************************************
3977: -- Handle DNB data in HZ_CREDIT_RATINGS
3978: FOR FROM_CR IN (
3979: SELECT credit_rating_id, rated_as_of_date
3980: FROM HZ_CREDIT_RATINGS
3981: WHERE actual_content_source = 'DNB'
3982: AND party_id = p_from_id) LOOP
3983:
3984:

Line 3987: FROM HZ_CREDIT_RATINGS

3983:
3984:
3985: BEGIN
3986: SELECT credit_rating_id INTO l_to
3987: FROM HZ_CREDIT_RATINGS
3988: WHERE actual_content_source = 'DNB'
3989: AND party_id = x_to_id
3990: AND trunc(rated_as_of_date)=trunc(FROM_CR.rated_as_of_date);
3991:

Line 3995: DELETE FROM HZ_CREDIT_RATINGS

3991:
3992: -- From Newer
3993: IF case1 OR (case3 and l_to_is_branch = 'Y') THEN
3994: -- Bug 3236556 - Delete the credit ratings of the to party
3995: DELETE FROM HZ_CREDIT_RATINGS
3996: WHERE credit_rating_id = l_to;
3997: -- Bug 3236556 - Since the to party no longer exists we must not insert a row with merge details.
3998: /*-- Merge to into from
3999: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 4001: 'HZ_CREDIT_RATINGS',

3997: -- Bug 3236556 - Since the to party no longer exists we must not insert a row with merge details.
3998: /*-- Merge to into from
3999: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4000: p_batch_party_id,
4001: 'HZ_CREDIT_RATINGS',
4002: l_to,
4003: FROM_CR.credit_rating_id,
4004: 'T',
4005: hz_utility_pub.created_by,

Line 4015: 'HZ_CREDIT_RATINGS',

4011: ELSE -- To Newer
4012: -- Merge from into to
4013: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4014: p_batch_party_id,
4015: 'HZ_CREDIT_RATINGS',
4016: FROM_CR.credit_rating_id,
4017: l_to,
4018: 'Y',
4019: hz_utility_pub.created_by,