APPS.IRC_IOF_BUS dependencies on IRC_TEMPLATE_ASSOCIATIONS

Line 1365: l_template_id irc_template_associations.template_id%TYPE;

1361: ,p_effective_date date
1362: ) IS
1363: --
1364: l_proc varchar2(72) := g_package || 'chk_template_id';
1365: l_template_id irc_template_associations.template_id%TYPE;
1366: l_api_updating boolean;
1367: --
1368: cursor csr_template_id is
1369: select 1

Line 1378: from irc_template_associations ita

1374: and nvl(end_date,p_effective_date);
1375: --
1376: cursor csr_default_template_job is
1377: select ita.template_id
1378: from irc_template_associations ita
1379: ,per_all_assignments_f ppaf
1380: ,irc_offers iof
1381: where ita.default_association = 'Y'
1382: and iof.offer_id = p_offer_id

Line 1388: from irc_template_associations ita

1384: and ita.job_id = ppaf.job_id;
1385: --
1386: cursor csr_default_template_pos is
1387: select ita.template_id
1388: from irc_template_associations ita
1389: ,per_all_assignments_f ppaf
1390: ,irc_offers iof
1391: where ita.default_association = 'Y'
1392: and iof.offer_id = p_offer_id

Line 1398: from irc_template_associations ita

1394: and ita.position_id = ppaf.position_id;
1395: --
1396: cursor csr_default_template_org is
1397: select ita.template_id
1398: from irc_template_associations ita
1399: ,per_all_assignments_f ppaf
1400: ,irc_offers iof
1401: where ita.default_association = 'Y'
1402: and iof.offer_id = p_offer_id