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