APPS.PAY_GB_P11D_PDF_CONTROL dependencies on DUAL

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

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

Line 165: from dual;

161: l_ret number;
162: begin
163: select mod(p_total,p_chunk_size)
164: into l_ret
165: from dual;
166: return l_ret;
167: end;
168:
169: function get_div(p_total number, p_chunk_size number) return number

Line 175: from dual;

171: l_val number;
172: begin
173: select floor(p_total / p_chunk_size)
174: into l_val
175: from dual;
176: return l_val;
177: end;
178: begin
179: l_asg_count := get_assignment_count;