APPS.IRC_VACANCY_COMMIT dependencies on IRC_ALL_RECRUITING_SITES

Line 2666: l_internal irc_all_recruiting_sites.INTERNAL%type;

2662: ----------------------------------------------------------
2663: FUNCTION is_site_internal (p_site_id varchar2
2664: ) return varchar2 IS
2665: --
2666: l_internal irc_all_recruiting_sites.INTERNAL%type;
2667: l_external irc_all_recruiting_sites.EXTERNAL%type;
2668: l_third_party irc_all_recruiting_sites.THIRD_PARTY%type;
2669: --
2670: cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is

Line 2667: l_external irc_all_recruiting_sites.EXTERNAL%type;

2663: FUNCTION is_site_internal (p_site_id varchar2
2664: ) return varchar2 IS
2665: --
2666: l_internal irc_all_recruiting_sites.INTERNAL%type;
2667: l_external irc_all_recruiting_sites.EXTERNAL%type;
2668: l_third_party irc_all_recruiting_sites.THIRD_PARTY%type;
2669: --
2670: cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is
2671: --

Line 2668: l_third_party irc_all_recruiting_sites.THIRD_PARTY%type;

2664: ) return varchar2 IS
2665: --
2666: l_internal irc_all_recruiting_sites.INTERNAL%type;
2667: l_external irc_all_recruiting_sites.EXTERNAL%type;
2668: l_third_party irc_all_recruiting_sites.THIRD_PARTY%type;
2669: --
2670: cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is
2671: --
2672: select INTERNAL, EXTERNAL, THIRD_PARTY

Line 2670: cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is

2666: l_internal irc_all_recruiting_sites.INTERNAL%type;
2667: l_external irc_all_recruiting_sites.EXTERNAL%type;
2668: l_third_party irc_all_recruiting_sites.THIRD_PARTY%type;
2669: --
2670: cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is
2671: --
2672: select INTERNAL, EXTERNAL, THIRD_PARTY
2673: from irc_all_recruiting_sites
2674: where RECRUITING_SITE_ID = c_site_id;

Line 2673: from irc_all_recruiting_sites

2669: --
2670: cursor csr_irs(c_site_id irc_all_recruiting_sites.RECRUITING_SITE_ID%type) is
2671: --
2672: select INTERNAL, EXTERNAL, THIRD_PARTY
2673: from irc_all_recruiting_sites
2674: where RECRUITING_SITE_ID = c_site_id;
2675: --
2676: BEGIN
2677: --