eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFERS_SWI dependencies on HR_API_TRANSACTIONS

Line 2863: from hr_api_transactions hrt, irc_offers iro

2859: ,offer_status
2860: ,applicant_assignment_id
2861: ,expiry_date
2862: ,object_version_number
2863: from hr_api_transactions hrt, irc_offers iro
2864: where hrt.transaction_id = p_transaction_id
2865: and hrt.transaction_ref_id = iro.offer_id;
2866: --
2867: cursor csr_offer_history_details(p_offer_id number) is

Line 3048: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;

3044: l_proc varchar2(72) := g_package || 'void_ben_records';
3045: l_void_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE;
3046: l_restore_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE := null;
3047: l_person_id per_all_assignments_f.person_id%TYPE := null;
3048: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3049: --
3050: cursor csr_applicant_assignment_id is
3051: select assignment_id
3052: from hr_api_transactions

Line 3052: from hr_api_transactions

3048: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3049: --
3050: cursor csr_applicant_assignment_id is
3051: select assignment_id
3052: from hr_api_transactions
3053: where transaction_id = p_transaction_id;
3054: --
3055: cursor csr_void_per_in_ler_id is
3056: select max(per_in_ler_id)