APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_ASSIGNMENT_SETS

Line 423: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;

419: -- assignment set parameter
420: ---------------------------------------------------------------------------
421: FUNCTION get_param_assignment_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
422: --
423: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;
424: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
425: --
426: CURSOR get_assignment_set_id IS
427: SELECT assignment_set_id

Line 424: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

420: ---------------------------------------------------------------------------
421: FUNCTION get_param_assignment_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
422: --
423: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;
424: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
425: --
426: CURSOR get_assignment_set_id IS
427: SELECT assignment_set_id
428: FROM hr_assignment_sets

Line 428: FROM hr_assignment_sets

424: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
425: --
426: CURSOR get_assignment_set_id IS
427: SELECT assignment_set_id
428: FROM hr_assignment_sets
429: WHERE assignment_set_name = l_assignment_set
430: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
431: --
432: BEGIN

Line 503: hr_assignment_sets has,

499: --
500: CURSOR check_asg_set_include(p_asg_id IN NUMBER) IS
501: SELECT 'Y' include_flag
502: FROM hr_assignment_set_amendments hasa,
503: hr_assignment_sets has,
504: per_all_assignments_f paaf
505: WHERE has.assignment_set_id = l_ext_asg_set_id
506: AND paaf.assignment_id = p_asg_id
507: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date