[Home] [Help]
2495: l_assignment_id number;
2496: l_assignment_number varchar2(100);
2497: l_element_type varchar2(200);
2498: l_account varchar2(1000);
2499: l_auto_org_name hr_all_organization_units_tl.name%TYPE;
2500: l_new_exp_type varchar2(30);
2501: l_new_glccid number;
2502:
2503: cursor get_element_type is
2513: hou.name
2514: from per_all_people_f ppf,
2515: per_all_assignments_f paf,
2516: pay_element_types_f pet,
2517: hr_all_organization_units hou
2518: where ppf.person_id = p_person_id
2519: and p_effective_date between paf.effective_start_date and paf.effective_end_date
2520: and paf.assignment_id = l_assignment_id
2521: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2728: AND p_business_group_id = hou.business_group_id
2729: AND paf.organization_id = hou.organization_id;
2730:
2731: v_organization_id number;
2732: v_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
2733: v_suspense_account number;
2734: v_return_status varchar2(1);
2735: assign_org_not_found exception;
2736: l_suspense_auto_glccid number;