APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_ASSIGNMENT_SETS

Line 386: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;

382: -- assignment set parameter
383: ---------------------------------------------------------------------------
384: FUNCTION get_param_assignment_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
385: --
386: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;
387: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
388: --
389: CURSOR get_assignment_set_id IS
390: SELECT assignment_set_id

Line 387: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

383: ---------------------------------------------------------------------------
384: FUNCTION get_param_assignment_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
385: --
386: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;
387: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
388: --
389: CURSOR get_assignment_set_id IS
390: SELECT assignment_set_id
391: FROM hr_assignment_sets

Line 391: FROM hr_assignment_sets

387: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
388: --
389: CURSOR get_assignment_set_id IS
390: SELECT assignment_set_id
391: FROM hr_assignment_sets
392: WHERE assignment_set_name = l_assignment_set
393: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
394: --
395: BEGIN

Line 466: hr_assignment_sets has,

462: --
463: CURSOR check_asg_set_include(p_asg_id IN NUMBER) IS
464: SELECT 'Y' include_flag
465: FROM hr_assignment_set_amendments hasa,
466: hr_assignment_sets has,
467: per_all_assignments_f paaf
468: WHERE has.assignment_set_id = l_ext_asg_set_id
469: AND paaf.assignment_id = p_asg_id
470: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date