APPS.IRC_OFFERS_SWI dependencies on BEN_PIL_ASSIGNMENT

Line 3045: l_void_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE;

3041: )
3042: is
3043: --
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: --

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

3042: is
3043: --
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

Line 3057: from ben_pil_assignment

3053: where transaction_id = p_transaction_id;
3054: --
3055: cursor csr_void_per_in_ler_id is
3056: select max(per_in_ler_id)
3057: from ben_pil_assignment
3058: where applicant_assignment_id = l_applicant_assignment_id
3059: and offer_assignment_id is null;
3060: --
3061: cursor csr_person_id is

Line 3071: from ben_pil_assignment

3067: and effective_end_date;
3068: --
3069: cursor csr_restore_per_in_ler_id is
3070: select max(per_in_ler_id)
3071: from ben_pil_assignment
3072: where applicant_assignment_id = l_applicant_assignment_id
3073: and offer_assignment_id is not null;
3074: --
3075: PRAGMA AUTONOMOUS_TRANSACTION;