APPS.IRC_OFFERS_SWI dependencies on BEN_PIL_ASSIGNMENT

Line 3022: l_void_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE;

3018: )
3019: is
3020: --
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: --

Line 3023: l_restore_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE := null;

3019: is
3020: --
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

Line 3034: from ben_pil_assignment

3030: where transaction_id = p_transaction_id;
3031: --
3032: cursor csr_void_per_in_ler_id is
3033: select max(per_in_ler_id)
3034: from ben_pil_assignment
3035: where applicant_assignment_id = l_applicant_assignment_id
3036: and offer_assignment_id is null;
3037: --
3038: cursor csr_person_id is

Line 3048: from ben_pil_assignment

3044: and effective_end_date;
3045: --
3046: cursor csr_restore_per_in_ler_id is
3047: select max(per_in_ler_id)
3048: from ben_pil_assignment
3049: where applicant_assignment_id = l_applicant_assignment_id
3050: and offer_assignment_id is not null;
3051: --
3052: PRAGMA AUTONOMOUS_TRANSACTION;