APPS.IRC_PENDING_DATA_API dependencies on IRC_POSTING_CONTENTS_VL

Line 1375: from irc_posting_contents_vl ipc

1371: and ipd.user_password is not null;
1372: --
1373: cursor csr_posting_title(p_posting_content_id in number) is
1374: select ipc.job_title
1375: from irc_posting_contents_vl ipc
1376: where ipc.posting_content_id = p_posting_content_id;
1377: --
1378: type vacancies_table is
1379: table of per_all_vacancies.name%type

Line 1387: table of irc_posting_contents_vl.job_title%type

1383: table of varchar2(1000)
1384: index by binary_integer;
1385: --
1386: type postings_table is
1387: table of irc_posting_contents_vl.job_title%type
1388: index by binary_integer;
1389: --
1390: l_resume varchar2(30);
1391: l_curr_email irc_pending_data.email_address%type;