APPS.IRC_IOF_BUS dependencies on IRC_TEMPLATE_ASSOCIATIONS

Line 1392: l_template_id irc_template_associations.template_id%TYPE;

1388: ,p_effective_date date
1389: ) IS
1390: --
1391: l_proc varchar2(72) := g_package || 'chk_template_id';
1392: l_template_id irc_template_associations.template_id%TYPE;
1393: l_api_updating boolean;
1394: --
1395: cursor csr_template_id is
1396: select 1

Line 1405: from irc_template_associations ita

1401: and nvl(end_date,p_effective_date);
1402: --
1403: cursor csr_default_template_job is
1404: select ita.template_id
1405: from irc_template_associations ita
1406: ,per_all_assignments_f ppaf
1407: ,irc_offers iof
1408: where ita.default_association = 'Y'
1409: and iof.offer_id = p_offer_id

Line 1415: from irc_template_associations ita

1411: and ita.job_id = ppaf.job_id;
1412: --
1413: cursor csr_default_template_pos is
1414: select ita.template_id
1415: from irc_template_associations ita
1416: ,per_all_assignments_f ppaf
1417: ,irc_offers iof
1418: where ita.default_association = 'Y'
1419: and iof.offer_id = p_offer_id

Line 1425: from irc_template_associations ita

1421: and ita.position_id = ppaf.position_id;
1422: --
1423: cursor csr_default_template_org is
1424: select ita.template_id
1425: from irc_template_associations ita
1426: ,per_all_assignments_f ppaf
1427: ,irc_offers iof
1428: where ita.default_association = 'Y'
1429: and iof.offer_id = p_offer_id