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 1037: from sys.dual;

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

Line 1954: from sys.dual;

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

Line 2110: from sys.dual;

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

Line 2202: from sys.dual;

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

Line 2261: from sys.dual;

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

Line 2326: from sys.dual;

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

Line 2364: from sys.dual;

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

Line 2400: from sys.dual;

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

Line 2510: from sys.dual;

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

Line 5026: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'

5022: ,wf_item_attribute_values choice_attribute
5023: ,wf_item_attribute_values submit_attribute
5024: ,wf_process_activities activity
5025: ,hr_api_transaction_steps step
5026: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'
5027: and activity.process_item_type = activity.activity_item_type
5028: and activity.instance_id = process.process_activity
5029: and process.activity_status = 'ACTIVE'
5030: and process.item_key = choice_attribute.item_key

Line 6010: from dual where exists( select null

6006: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT');
6007: --
6008: cursor c_exists_prev_other_option is
6009: select 'Y'
6010: from dual where exists( select null
6011: from ben_elig_cvrd_dpnt_f pdp,
6012: ben_per_in_ler pil,
6013: ben_prtt_enrt_rslt_f pnr,
6014: ben_prtt_enrt_rslt_f pen