DBA Data[Home] [Help]

APPS.HZ_PARTY_MERGE dependencies on HZ_FINANCIAL_NUMBERS

Line 4124: DELETE FROM HZ_FINANCIAL_NUMBERS

4120: /*Bug 3236556*/
4121: DELETE FROM HZ_FINANCIAL_REPORTS
4122: WHERE financial_report_id = l_to;
4123:
4124: DELETE FROM HZ_FINANCIAL_NUMBERS
4125: WHERE financial_report_id = l_to;
4126:
4127: /*
4128: UPDATE HZ_FINANCIAL_REPORTS

Line 4139: UPDATE HZ_FINANCIAL_NUMBERS

4135: program_id = hz_utility_pub.program_id,
4136: program_update_date = sysdate
4137: WHERE financial_report_id = l_to;
4138:
4139: UPDATE HZ_FINANCIAL_NUMBERS
4140: SET status='I',
4141: last_update_date = hz_utility_pub.last_update_date,
4142: last_updated_by = hz_utility_pub.user_id,
4143: last_update_login = hz_utility_pub.last_update_login,

Line 4162: UPDATE HZ_FINANCIAL_NUMBERS

4158: program_id = hz_utility_pub.program_id,
4159: program_update_date = sysdate
4160: WHERE financial_report_id = FROM_FR.financial_report_id;
4161:
4162: UPDATE HZ_FINANCIAL_NUMBERS
4163: SET status='M',
4164: last_update_date = hz_utility_pub.last_update_date,
4165: last_updated_by = hz_utility_pub.user_id,
4166: last_update_login = hz_utility_pub.last_update_login,