APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on HR_ASSIGNMENT_SETS

Line 247: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;

243: -- assignment set parameter
244: ---------------------------------------------------------------------------
245: FUNCTION get_param_assignment_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
246: --
247: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;
248: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
249: --
250: CURSOR get_assignment_set_id IS
251: SELECT assignment_set_id

Line 248: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

244: ---------------------------------------------------------------------------
245: FUNCTION get_param_assignment_set_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
246: --
247: l_assignment_set hr_assignment_sets.assignment_set_name%TYPE;
248: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
249: --
250: CURSOR get_assignment_set_id IS
251: SELECT assignment_set_id
252: FROM hr_assignment_sets

Line 252: FROM hr_assignment_sets

248: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
249: --
250: CURSOR get_assignment_set_id IS
251: SELECT assignment_set_id
252: FROM hr_assignment_sets
253: WHERE assignment_set_name = l_assignment_set
254: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
255: --
256: BEGIN

Line 999: hr_assignment_sets has,

995: --
996: CURSOR check_asg_set_include(p_asg_id IN NUMBER) IS
997: SELECT 'Y' include_flag
998: FROM hr_assignment_set_amendments hasa,
999: hr_assignment_sets has,
1000: per_all_assignments_f paaf
1001: WHERE has.assignment_set_id = l_ext_asg_set_id
1002: AND paaf.assignment_id = p_asg_id
1003: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date