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 2859: from hr_api_transactions hrt, irc_offers iro

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

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

3021: l_proc varchar2(72) := g_package || 'void_ben_records';
3022: l_void_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE;
3023: l_restore_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE := null;
3024: l_person_id per_all_assignments_f.person_id%TYPE := null;
3025: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3026: --
3027: cursor csr_applicant_assignment_id is
3028: select assignment_id
3029: from hr_api_transactions

Line 3029: from hr_api_transactions

3025: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3026: --
3027: cursor csr_applicant_assignment_id is
3028: select assignment_id
3029: from hr_api_transactions
3030: where transaction_id = p_transaction_id;
3031: --
3032: cursor csr_void_per_in_ler_id is
3033: select max(per_in_ler_id)