APPS.PER_IE_ORG_INFO dependencies on PER_ALL_ASSIGNMENTS_F

Line 285: from per_all_assignments_f paa,

281:
282: select 1
283: from dual
284: where exists(select NULL
285: from per_all_assignments_f paa,
286: pay_all_payrolls_f pap,
287: hr_soft_coding_keyflex scl
288: where paa.payroll_id = pap.payroll_id
289: and p_effective_date not between paa.effective_start_date and paa.effective_end_date

Line 311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;

307: and pay.business_group_id=p_business_group_id;
308:
309: l_old_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
310: l_new_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;
312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
313: l_person_id per_all_people_f.person_id%type;
314: l_assignment_id per_all_assignments_f.assignment_id%type;
315: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

Line 312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;

308:
309: l_old_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
310: l_new_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;
312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
313: l_person_id per_all_people_f.person_id%type;
314: l_assignment_id per_all_assignments_f.assignment_id%type;
315: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
316: l_er_exists number;

Line 314: l_assignment_id per_all_assignments_f.assignment_id%type;

310: l_new_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;
312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
313: l_person_id per_all_people_f.person_id%type;
314: l_assignment_id per_all_assignments_f.assignment_id%type;
315: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
316: l_er_exists number;
317:
318: BEGIN