APPS.PAY_ZA_EOY_VAL dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 1790: FROM hr_assignment_set_amendments hasa

1786: )
1787: as
1788: CURSOR get_asg_set_status(c_asg_set_id hr_assignment_sets.assignment_set_id%TYPE) IS
1789: SELECT include_or_exclude
1790: FROM hr_assignment_set_amendments hasa
1791: WHERE hasa.assignment_set_id = c_asg_set_id;
1792:
1793: l_ass_set_name varchar2(80);
1794: l_set_flag varchar2(1);

Line 1854: g_asg_set_where := ' AND ass.assignment_id NOT IN ( SELECT hasa.assignment_id FROM hr_assignment_set_amendments hasa WHERE hasa.assignment_set_id = ' || P_ASG_SET_ID || ' AND hasa.assignment_id = ass.assignment_id) ';

1850: OPEN get_asg_set_status(P_ASG_SET_ID);
1851: FETCH get_asg_set_status INTO l_set_flag;
1852:
1853: IF l_set_flag = 'E' THEN -- if EXCLUDE
1854: g_asg_set_where := ' AND ass.assignment_id NOT IN ( SELECT hasa.assignment_id FROM hr_assignment_set_amendments hasa WHERE hasa.assignment_set_id = ' || P_ASG_SET_ID || ' AND hasa.assignment_id = ass.assignment_id) ';
1855:
1856: ELSIF l_set_flag = 'I' THEN -- if INCLUDE
1857: g_asg_set_where := ' AND ass.assignment_id IN ( SELECT hasa.assignment_id FROM hr_assignment_set_amendments hasa WHERE hasa.assignment_set_id = ' || P_ASG_SET_ID || ' AND hasa.assignment_id = ass.assignment_id) ';
1858: ELSE -- Select all assignments assigned to the payroll associated with this assignment set

Line 1857: g_asg_set_where := ' AND ass.assignment_id IN ( SELECT hasa.assignment_id FROM hr_assignment_set_amendments hasa WHERE hasa.assignment_set_id = ' || P_ASG_SET_ID || ' AND hasa.assignment_id = ass.assignment_id) ';

1853: IF l_set_flag = 'E' THEN -- if EXCLUDE
1854: g_asg_set_where := ' AND ass.assignment_id NOT IN ( SELECT hasa.assignment_id FROM hr_assignment_set_amendments hasa WHERE hasa.assignment_set_id = ' || P_ASG_SET_ID || ' AND hasa.assignment_id = ass.assignment_id) ';
1855:
1856: ELSIF l_set_flag = 'I' THEN -- if INCLUDE
1857: g_asg_set_where := ' AND ass.assignment_id IN ( SELECT hasa.assignment_id FROM hr_assignment_set_amendments hasa WHERE hasa.assignment_set_id = ' || P_ASG_SET_ID || ' AND hasa.assignment_id = ass.assignment_id) ';
1858: ELSE -- Select all assignments assigned to the payroll associated with this assignment set
1859: g_asg_set_where := ' AND 1= 1 ';
1860: END IF;
1861: