APPS.PER_IE_ORG_INFO dependencies on DUAL

Line 111: from dual

107: l_trace number(2):=1;
108: l_flag boolean:=TRUE;
109: l_last_digit char(1);
110: cursor c_cbr_no is select cbr from (select substr(p_cbr_no ,level-0,1) cbr
111: from dual
112: connect by level 113: l_cbr_no c_cbr_no%rowtype;
114:
115: begin

Line 283: from dual

279: p_assignment_id number,
280: p_effective_date date) IS
281:
282: select 1
283: from dual
284: where exists(select NULL
285: from per_all_assignments_f paa,
286: pay_all_payrolls_f pap,
287: hr_soft_coding_keyflex scl