APPS.PAY_GB_P11D_PDF_CONTROL dependencies on DUAL

Line 121: select ' || p_org_hierarchy || ' from dual)';

117: l_where := l_where || ' and emp.action_information2 in(select organization_id_child
118: from per_org_structure_elements
119: where business_group_id = ' || p_org_hierarchy ||
120: ' union
121: select ' || p_org_hierarchy || ' from dual)';
122: end if;
123: if p_assignment_set_id is not null then
124: l_from := l_from || ',hr_assignment_sets has
125: ,hr_assignment_set_amendments hasa ';

Line 169: from dual;

165: l_ret number;
166: begin
167: select mod(p_total,p_chunk_size)
168: into l_ret
169: from dual;
170: return l_ret;
171: end;
172:
173: function get_div(p_total number, p_chunk_size number) return number

Line 179: from dual;

175: l_val number;
176: begin
177: select floor(p_total / p_chunk_size)
178: into l_val
179: from dual;
180: return l_val;
181: end;
182: begin
183: l_asg_count := get_assignment_count;