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.BENUTILS dependencies on DUAL

Line 1040: from sys.dual;

1036: l_num1_col.extend(1);
1037: --
1038: select ben_reporting_s.nextval into
1039: l_num1_col(l_count)
1040: from sys.dual;
1041: /*
1042: l_num1_col(l_count) :=
1043: g_report_table_object(l_count).reporting_id;
1044: */

Line 1957: from sys.dual;

1953: l_count := g_report_table_object.count;
1954: /*
1955: select ben_reporting_s.nextval into
1956: g_report_table_object(l_count).reporting_id
1957: from sys.dual;
1958: */
1959: g_report_table_object(l_count).reporting_id := null;
1960: g_report_table_object(l_count).benefit_action_id := g_benefit_action_id;
1961: g_report_table_object(l_count).thread_id := g_thread_id;

Line 2113: from sys.dual;

2109: g_batch_elig_table_object.extend(1);
2110: l_count := g_batch_elig_table_object.count;
2111: select ben_batch_elig_info_s.nextval into
2112: g_batch_elig_table_object(l_count).batch_elig_id
2113: from sys.dual;
2114: --
2115: g_batch_elig_table_object(l_count).benefit_action_id := g_benefit_action_id;
2116: g_batch_elig_table_object(l_count).person_id := p_rec.person_id;
2117: g_batch_elig_table_object(l_count).pgm_id := p_rec.pgm_id;

Line 2205: from sys.dual;

2201: g_batch_elctbl_table_object.extend(1);
2202: l_count := g_batch_elctbl_table_object.count;
2203: select ben_batch_elctbl_chc_info_s.nextval into
2204: g_batch_elctbl_table_object(l_count).batch_elctbl_id
2205: from sys.dual;
2206: --
2207: g_batch_elctbl_table_object(l_count).benefit_action_id := g_benefit_action_id;
2208: g_batch_elctbl_table_object(l_count).person_id := p_rec.person_id;
2209: g_batch_elctbl_table_object(l_count).pgm_id := p_rec.pgm_id;

Line 2264: from sys.dual;

2260: g_batch_rate_table_object.extend(1);
2261: l_count := g_batch_rate_table_object.count;
2262: select ben_batch_rate_info_s.nextval into
2263: g_batch_rate_table_object(l_count).batch_rt_id
2264: from sys.dual;
2265: --
2266: g_batch_rate_table_object(l_count).benefit_action_id := g_benefit_action_id;
2267: g_batch_rate_table_object(l_count).person_id := p_rec.person_id;
2268: g_batch_rate_table_object(l_count).pgm_id := p_rec.pgm_id;

Line 2329: from sys.dual;

2325: g_batch_dpnt_table_object.extend(1);
2326: l_count := g_batch_dpnt_table_object.count;
2327: select ben_batch_dpnt_info_s.nextval into
2328: g_batch_dpnt_table_object(l_count).batch_dpnt_id
2329: from sys.dual;
2330: --
2331: g_batch_dpnt_table_object(l_count).benefit_action_id := g_benefit_action_id;
2332: g_batch_dpnt_table_object(l_count).person_id := p_rec.person_id;
2333: g_batch_dpnt_table_object(l_count).pgm_id := p_rec.pgm_id;

Line 2367: from sys.dual;

2363: g_batch_commu_table_object.extend(1);
2364: l_count := g_batch_commu_table_object.count;
2365: select ben_batch_commu_info_s.nextval into
2366: g_batch_commu_table_object(l_count).batch_commu_id
2367: from sys.dual;
2368: --
2369: g_batch_commu_table_object(l_count).benefit_action_id := g_benefit_action_id;
2370: g_batch_commu_table_object(l_count).person_id := p_rec.person_id;
2371: g_batch_commu_table_object(l_count).per_cm_id := p_rec.per_cm_id;

Line 2403: from sys.dual;

2399: g_batch_ler_table_object.extend(1);
2400: l_count := g_batch_ler_table_object.count;
2401: select ben_batch_ler_info_s.nextval into
2402: g_batch_ler_table_object(l_count).batch_ler_id
2403: from sys.dual;
2404: --
2405: g_batch_ler_table_object(l_count).benefit_action_id := g_benefit_action_id;
2406: g_batch_ler_table_object(l_count).person_id := p_rec.person_id;
2407: g_batch_ler_table_object(l_count).ler_id := p_rec.ler_id;

Line 2513: from sys.dual;

2509: l_count := g_report_table_object.count;
2510: /*
2511: select ben_reporting_s.nextval into
2512: g_report_table_object(l_count).reporting_id
2513: from sys.dual;
2514: */
2515: g_report_table_object(l_count).reporting_id := null;
2516: g_report_table_object(l_count).benefit_action_id := g_benefit_action_id;
2517: g_report_table_object(l_count).thread_id := g_thread_id;

Line 5151: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'

5147: ,wf_item_attribute_values choice_attribute
5148: ,wf_item_attribute_values submit_attribute
5149: ,wf_process_activities activity
5150: ,hr_api_transaction_steps step
5151: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'
5152: and activity.process_item_type = activity.activity_item_type
5153: and activity.instance_id = process.process_activity
5154: and process.activity_status = 'ACTIVE'
5155: and process.item_key = choice_attribute.item_key

Line 6135: from dual where exists( select null

6131: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT');
6132: --
6133: cursor c_exists_prev_other_option is
6134: select 'Y'
6135: from dual where exists( select null
6136: from ben_elig_cvrd_dpnt_f pdp,
6137: ben_per_in_ler pil,
6138: ben_prtt_enrt_rslt_f pnr,
6139: ben_prtt_enrt_rslt_f pen