APPS.IRC_OFFERS_SWI dependencies on PER_ALL_ASSIGNMENTS_F

Line 961: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

957: l_hourly_salaried_warning boolean;
958: l_validate boolean;
959: --
960: -- Variables for IN/OUT parameters
961: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
962: --
963: -- Other variables
964: l_proc varchar2(72) := g_package ||'create_offer_assignment';
965: Begin

Line 1934: l_offer_assignment_record per_all_assignments_f%rowtype;

1930: ,p_return_status out nocopy varchar2
1931: ) is
1932: --
1933: l_proc varchar2(72) := g_package ||'is_run_benmgle_for_irec_reqd';
1934: l_offer_assignment_record per_all_assignments_f%rowtype;
1935: l_pay_proposal_record per_pay_proposals%rowtype;
1936: --
1937: Begin
1938: hr_utility.set_location(' Entering:' || l_proc,10);

Line 2293: l_offer_assignment_record per_all_assignments_f%rowtype;

2289: ,p_return_status out nocopy varchar2
2290: ) is
2291: --
2292: l_proc varchar2(72) := g_package ||'run_benmgle_for_irec';
2293: l_offer_assignment_record per_all_assignments_f%rowtype;
2294: --
2295: Begin
2296: hr_utility.set_location(' Entering:' || l_proc,10);
2297: --

Line 3024: l_person_id per_all_assignments_f.person_id%TYPE := null;

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
3028: select assignment_id

Line 3040: from per_all_assignments_f

3036: and offer_assignment_id is null;
3037: --
3038: cursor csr_person_id is
3039: select person_id
3040: from per_all_assignments_f
3041: where assignment_id = l_applicant_assignment_id
3042: and trunc(sysdate)
3043: between effective_start_date
3044: and effective_end_date;