APPS.PAY_ZA_EOY_VAL dependencies on HR_ASSIGNMENT_SETS

Line 1788: CURSOR get_asg_set_status(c_asg_set_id hr_assignment_sets.assignment_set_id%TYPE) IS

1784: -- P_ASG_SET_WHERE varchar2,
1785: -- P_SORT_ORDER_CLAUSE varchar2
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:

Line 1847: from hr_assignment_sets

1843: --Assignment Set Info
1844: if P_ASG_SET_ID is not null
1845: then
1846: select assignment_set_name into l_ass_set_name
1847: from hr_assignment_sets
1848: where assignment_set_id=P_ASG_SET_ID;
1849:
1850: OPEN get_asg_set_status(P_ASG_SET_ID);
1851: FETCH get_asg_set_status INTO l_set_flag;