APPS.IRC_OFFERS_SWI dependencies on PER_ALL_ASSIGNMENTS_F

Line 965: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

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

Line 1938: l_offer_assignment_record per_all_assignments_f%rowtype;

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

Line 2297: l_offer_assignment_record per_all_assignments_f%rowtype;

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

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

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

Line 3063: from per_all_assignments_f

3059: and offer_assignment_id is null;
3060: --
3061: cursor csr_person_id is
3062: select person_id
3063: from per_all_assignments_f
3064: where assignment_id = l_applicant_assignment_id
3065: and trunc(sysdate)
3066: between effective_start_date
3067: and effective_end_date;