DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on PER_ASSIGNMENTS_V

Line 223: l_super_assgn_num per_assignments_v.supervisor_assignment_number%type;

219: (p_supervisor_assgn_id number
220: ,p_business_group_id number) return varchar2 is
221: --
222: l_proc varchar2(72) :=g_package||'get_supervisor_assgn_number';
223: l_super_assgn_num per_assignments_v.supervisor_assignment_number%type;
224: --
225: /* Fix for the bug 14195421
226: cursor csr_super_assgn_num is
227: select supervisor_assignment_number

Line 228: from per_assignments_v

224: --
225: /* Fix for the bug 14195421
226: cursor csr_super_assgn_num is
227: select supervisor_assignment_number
228: from per_assignments_v
229: where supervisor_assignment_id = p_supervisor_assgn_id
230: and business_group_id = p_business_group_id; */
231:
232: cursor csr_super_assgn_num is