eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EFC_ADJUSTMENTS dependencies on HR_EFC_INFO

Line 1617: hr_efc_info.insert_line('-- ');

1613: ||' order by pep.elig_per_id ';
1614: --
1615: if l_efc_batch then
1616: --
1617: hr_efc_info.insert_line('-- ');
1618: hr_efc_info.insert_line('-- Adjusting elig pers ');
1619: hr_efc_info.insert_line('-- ');
1620: --
1621: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;

Line 1618: hr_efc_info.insert_line('-- Adjusting elig pers ');

1614: --
1615: if l_efc_batch then
1616: --
1617: hr_efc_info.insert_line('-- ');
1618: hr_efc_info.insert_line('-- Adjusting elig pers ');
1619: hr_efc_info.insert_line('-- ');
1620: --
1621: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
1622: --

Line 1619: hr_efc_info.insert_line('-- ');

1615: if l_efc_batch then
1616: --
1617: hr_efc_info.insert_line('-- ');
1618: hr_efc_info.insert_line('-- Adjusting elig pers ');
1619: hr_efc_info.insert_line('-- ');
1620: --
1621: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
1622: --
1623: elsif p_valworker_id is not null

Line 2307: hr_efc_info.insert_line('-- ');

2303: ||' order by epo.elig_per_opt_id ';
2304: --
2305: if l_efc_batch then
2306: --
2307: hr_efc_info.insert_line('-- ');
2308: hr_efc_info.insert_line('-- Adjusting elig per options ');
2309: hr_efc_info.insert_line('-- ');
2310: --
2311: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;

Line 2308: hr_efc_info.insert_line('-- Adjusting elig per options ');

2304: --
2305: if l_efc_batch then
2306: --
2307: hr_efc_info.insert_line('-- ');
2308: hr_efc_info.insert_line('-- Adjusting elig per options ');
2309: hr_efc_info.insert_line('-- ');
2310: --
2311: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
2312: --

Line 2309: hr_efc_info.insert_line('-- ');

2305: if l_efc_batch then
2306: --
2307: hr_efc_info.insert_line('-- ');
2308: hr_efc_info.insert_line('-- Adjusting elig per options ');
2309: hr_efc_info.insert_line('-- ');
2310: --
2311: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
2312: --
2313: elsif p_valworker_id is not null

Line 3100: hr_efc_info.insert_line('-- ');

3096: ||' order by enb.enrt_bnft_id ';
3097: --
3098: if l_efc_batch then
3099: --
3100: hr_efc_info.insert_line('-- ');
3101: hr_efc_info.insert_line('-- Adjusting coverages ');
3102: hr_efc_info.insert_line('-- ');
3103: --
3104: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;

Line 3101: hr_efc_info.insert_line('-- Adjusting coverages ');

3097: --
3098: if l_efc_batch then
3099: --
3100: hr_efc_info.insert_line('-- ');
3101: hr_efc_info.insert_line('-- Adjusting coverages ');
3102: hr_efc_info.insert_line('-- ');
3103: --
3104: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
3105: --

Line 3102: hr_efc_info.insert_line('-- ');

3098: if l_efc_batch then
3099: --
3100: hr_efc_info.insert_line('-- ');
3101: hr_efc_info.insert_line('-- Adjusting coverages ');
3102: hr_efc_info.insert_line('-- ');
3103: --
3104: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
3105: --
3106: elsif p_valworker_id is not null

Line 4130: hr_efc_info.insert_line('-- ');

4126: ||' order by epr.enrt_prem_id ';
4127: --
4128: if l_efc_batch then
4129: --
4130: hr_efc_info.insert_line('-- ');
4131: hr_efc_info.insert_line('-- Adjusting enrolment premiums ');
4132: hr_efc_info.insert_line('-- ');
4133: --
4134: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;

Line 4131: hr_efc_info.insert_line('-- Adjusting enrolment premiums ');

4127: --
4128: if l_efc_batch then
4129: --
4130: hr_efc_info.insert_line('-- ');
4131: hr_efc_info.insert_line('-- Adjusting enrolment premiums ');
4132: hr_efc_info.insert_line('-- ');
4133: --
4134: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
4135: --

Line 4132: hr_efc_info.insert_line('-- ');

4128: if l_efc_batch then
4129: --
4130: hr_efc_info.insert_line('-- ');
4131: hr_efc_info.insert_line('-- Adjusting enrolment premiums ');
4132: hr_efc_info.insert_line('-- ');
4133: --
4134: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
4135: --
4136: elsif p_valworker_id is not null

Line 4914: hr_efc_info.insert_line('-- ');

4910: /*
4911: l_sql_str := l_sql_str||' FOR UPDATE OF ecr.enrt_rt_id ';
4912: --
4913: */
4914: hr_efc_info.insert_line('-- ');
4915: hr_efc_info.insert_line('-- Adjusting enrolment rates. Worker: '||p_worker_id
4916: ||' of '||p_total_workers
4917: );
4918: hr_efc_info.insert_line('-- ');

Line 4915: hr_efc_info.insert_line('-- Adjusting enrolment rates. Worker: '||p_worker_id

4911: l_sql_str := l_sql_str||' FOR UPDATE OF ecr.enrt_rt_id ';
4912: --
4913: */
4914: hr_efc_info.insert_line('-- ');
4915: hr_efc_info.insert_line('-- Adjusting enrolment rates. Worker: '||p_worker_id
4916: ||' of '||p_total_workers
4917: );
4918: hr_efc_info.insert_line('-- ');
4919: --

Line 4918: hr_efc_info.insert_line('-- ');

4914: hr_efc_info.insert_line('-- ');
4915: hr_efc_info.insert_line('-- Adjusting enrolment rates. Worker: '||p_worker_id
4916: ||' of '||p_total_workers
4917: );
4918: hr_efc_info.insert_line('-- ');
4919: --
4920: open c_efc_rows FOR l_sql_str using p_action_id, p_pk1, p_total_workers, p_worker_id;
4921: --
4922: elsif p_valworker_id is not null

Line 4930: hr_efc_info.insert_line('-- ');

4926: open c_efc_rows FOR l_sql_str using p_valtotal_workers, p_valworker_id;
4927: --
4928: else
4929: --
4930: hr_efc_info.insert_line('-- ');
4931: hr_efc_info.insert_line('-- Validating enrolment rate adjustments');
4932: hr_efc_info.insert_line('-- ');
4933: --
4934: open c_efc_rows FOR l_sql_str;

Line 4931: hr_efc_info.insert_line('-- Validating enrolment rate adjustments');

4927: --
4928: else
4929: --
4930: hr_efc_info.insert_line('-- ');
4931: hr_efc_info.insert_line('-- Validating enrolment rate adjustments');
4932: hr_efc_info.insert_line('-- ');
4933: --
4934: open c_efc_rows FOR l_sql_str;
4935: --

Line 4932: hr_efc_info.insert_line('-- ');

4928: else
4929: --
4930: hr_efc_info.insert_line('-- ');
4931: hr_efc_info.insert_line('-- Validating enrolment rate adjustments');
4932: hr_efc_info.insert_line('-- ');
4933: --
4934: open c_efc_rows FOR l_sql_str;
4935: --
4936: end if;