DBA Data[Home] [Help]

APPS.HZ_PARTY_MERGE dependencies on HZ_FINANCIAL_NUMBERS

Line 4526: DELETE FROM HZ_FINANCIAL_NUMBERS

4522: /*Bug 3236556*/
4523: DELETE FROM HZ_FINANCIAL_REPORTS
4524: WHERE financial_report_id = l_to;
4525:
4526: DELETE FROM HZ_FINANCIAL_NUMBERS
4527: WHERE financial_report_id = l_to;
4528:
4529: /*
4530: UPDATE HZ_FINANCIAL_REPORTS

Line 4541: UPDATE HZ_FINANCIAL_NUMBERS

4537: program_id = hz_utility_pub.program_id,
4538: program_update_date = sysdate
4539: WHERE financial_report_id = l_to;
4540:
4541: UPDATE HZ_FINANCIAL_NUMBERS
4542: SET status='I',
4543: last_update_date = hz_utility_pub.last_update_date,
4544: last_updated_by = hz_utility_pub.user_id,
4545: last_update_login = hz_utility_pub.last_update_login,

Line 4564: UPDATE HZ_FINANCIAL_NUMBERS

4560: program_id = hz_utility_pub.program_id,
4561: program_update_date = sysdate
4562: WHERE financial_report_id = FROM_FR.financial_report_id;
4563:
4564: UPDATE HZ_FINANCIAL_NUMBERS
4565: SET status='M',
4566: last_update_date = hz_utility_pub.last_update_date,
4567: last_updated_by = hz_utility_pub.user_id,
4568: last_update_login = hz_utility_pub.last_update_login,