APPS.IRC_INTERVIEW_DETAILS_API dependencies on IRC_INTERVIEW_DETAILS_S

Line 55: l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';

51: l_interview_details_id number;
52: l_object_version_number number;
53: l_start_date date;
54: l_end_date date;
55: l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';
56: l_effective_date date;
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --

Line 487: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;

483: --
484: l_event_rec per_events%rowtype;
485: l_interview_det_rec irc_interview_details%rowtype;
486: --
487: Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;
488: --
489: Cursor csr_event_rec (p_assignment_id per_events.assignment_id%type)
490: is
491: select *