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: cursor csr_super_assgn_num is
226: select supervisor_assignment_number
227: from per_assignments_v

Line 227: from per_assignments_v

223: l_super_assgn_num per_assignments_v.supervisor_assignment_number%type;
224: --
225: cursor csr_super_assgn_num is
226: select supervisor_assignment_number
227: from per_assignments_v
228: where supervisor_assignment_id = p_supervisor_assgn_id
229: and business_group_id = p_business_group_id;
230:
231: begin