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_RECN_REP dependencies on HR_GENERAL

Line 250: from (select distinct hr_general.decode_organization(asg.organization_id) pl_oraganization_name

246: sum(ee_ptax_elem_val) ee_ptax_elem_val_tot,
247: sum(ee_atax_elem_val) ee_atax_elem_val_tot,
248: sum(er_elem_val ) er_elem_val_tot ,
249: sum(ee_ptax_elem_val + ee_atax_elem_val + er_elem_val) actual_total
250: from (select distinct hr_general.decode_organization(asg.organization_id) pl_oraganization_name
251: ,hr_general.decode_location(asg.location_id) pl_location_name
252: ,pay.payroll_name pl_payroll_name
253: ,decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' || -- the japanese name format should be kept in sync with hrjputil.pkb
254: per.per_information18 || ' ' || per.per_information19)

Line 251: ,hr_general.decode_location(asg.location_id) pl_location_name

247: sum(ee_atax_elem_val) ee_atax_elem_val_tot,
248: sum(er_elem_val ) er_elem_val_tot ,
249: sum(ee_ptax_elem_val + ee_atax_elem_val + er_elem_val) actual_total
250: from (select distinct hr_general.decode_organization(asg.organization_id) pl_oraganization_name
251: ,hr_general.decode_location(asg.location_id) pl_location_name
252: ,pay.payroll_name pl_payroll_name
253: ,decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' || -- the japanese name format should be kept in sync with hrjputil.pkb
254: per.per_information18 || ' ' || per.per_information19)
255: , per.full_name) pl_full_name

Line 353: from (select distinct hr_general.decode_organization(asg.organization_id) pl_oraganization_name

349: ,ee_ptax_elem_val + ee_atax_elem_val + er_elem_val actual_total
350: ,((ee_ptax_elem_val + ee_atax_elem_val + er_elem_val) -
351: (ee_ptax_rt_val + ee_atax_rt_val + er_rt_val)) std_rt_dis
352: ,nvl(((ee_ptax_elem_val + ee_atax_elem_val + er_elem_val ) - pl_prem_val),0) prem_dis
353: from (select distinct hr_general.decode_organization(asg.organization_id) pl_oraganization_name
354: ,hr_general.decode_location(asg.location_id) pl_location_name
355: ,pay.payroll_name pl_payroll_name
356: ,decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' || -- the japanese name format should be kept in sync with hrjputil.pkb
357: per.per_information18 || ' ' || per.per_information19)

Line 354: ,hr_general.decode_location(asg.location_id) pl_location_name

350: ,((ee_ptax_elem_val + ee_atax_elem_val + er_elem_val) -
351: (ee_ptax_rt_val + ee_atax_rt_val + er_rt_val)) std_rt_dis
352: ,nvl(((ee_ptax_elem_val + ee_atax_elem_val + er_elem_val ) - pl_prem_val),0) prem_dis
353: from (select distinct hr_general.decode_organization(asg.organization_id) pl_oraganization_name
354: ,hr_general.decode_location(asg.location_id) pl_location_name
355: ,pay.payroll_name pl_payroll_name
356: ,decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' || -- the japanese name format should be kept in sync with hrjputil.pkb
357: per.per_information18 || ' ' || per.per_information19)
358: , per.full_name) pl_full_name

Line 453: select hr_general.decode_organization(asg.organization_id) lf_org_name,

449: order by 1,2,3,4;
450: --
451: cursor c_lf_prem is
452: select * from (
453: select hr_general.decode_organization(asg.organization_id) lf_org_name,
454: hr_general.decode_location(asg.location_id) lf_location_name,
455: hr_general.decode_payroll(asg.payroll_id) lf_payroll_name,
456: decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' ||
457: per.per_information18 || ' ' || per.per_information19)

Line 454: hr_general.decode_location(asg.location_id) lf_location_name,

450: --
451: cursor c_lf_prem is
452: select * from (
453: select hr_general.decode_organization(asg.organization_id) lf_org_name,
454: hr_general.decode_location(asg.location_id) lf_location_name,
455: hr_general.decode_payroll(asg.payroll_id) lf_payroll_name,
456: decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' ||
457: per.per_information18 || ' ' || per.per_information19)
458: , per.full_name) lf_full_name,

Line 455: hr_general.decode_payroll(asg.payroll_id) lf_payroll_name,

451: cursor c_lf_prem is
452: select * from (
453: select hr_general.decode_organization(asg.organization_id) lf_org_name,
454: hr_general.decode_location(asg.location_id) lf_location_name,
455: hr_general.decode_payroll(asg.payroll_id) lf_payroll_name,
456: decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' ||
457: per.per_information18 || ' ' || per.per_information19)
458: , per.full_name) lf_full_name,
459: per.national_identifier lf_national_identifier ,

Line 540: hr_general.decode_organization(asg.organization_id) prtt_org_name,

536: where lf_old_prem <> lf_val ;
537: --
538: cursor c_pl_oipl is
539: select distinct decode(apr.pl_id,null,'OIPL','PL') levels ,
540: hr_general.decode_organization(asg.organization_id) prtt_org_name,
541: hr_general.decode_location(asg.location_id) prtt_location_name,
542: hr_general.decode_payroll(asg.payroll_id) prtt_payroll_name,
543: decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' ||
544: per.per_information18 || ' ' || per.per_information19)

Line 541: hr_general.decode_location(asg.location_id) prtt_location_name,

537: --
538: cursor c_pl_oipl is
539: select distinct decode(apr.pl_id,null,'OIPL','PL') levels ,
540: hr_general.decode_organization(asg.organization_id) prtt_org_name,
541: hr_general.decode_location(asg.location_id) prtt_location_name,
542: hr_general.decode_payroll(asg.payroll_id) prtt_payroll_name,
543: decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' ||
544: per.per_information18 || ' ' || per.per_information19)
545: , per.full_name) full_name ,

Line 542: hr_general.decode_payroll(asg.payroll_id) prtt_payroll_name,

538: cursor c_pl_oipl is
539: select distinct decode(apr.pl_id,null,'OIPL','PL') levels ,
540: hr_general.decode_organization(asg.organization_id) prtt_org_name,
541: hr_general.decode_location(asg.location_id) prtt_location_name,
542: hr_general.decode_payroll(asg.payroll_id) prtt_payroll_name,
543: decode(p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' ||
544: per.per_information18 || ' ' || per.per_information19)
545: , per.full_name) full_name ,
546: per.national_identifier,

Line 1871: p_ret_emp_name_format := hr_general.decode_lookup('BEN_PER_NAME_FMT',p_emp_name_format );

1867: else
1868: p_ret_person := l_all;
1869: end if;
1870: --
1871: p_ret_emp_name_format := hr_general.decode_lookup('BEN_PER_NAME_FMT',p_emp_name_format );
1872: --
1873: if p_pgm_id is not null then
1874: p_ret_pgm := ben_batch_utils.get_pgm_name(p_pgm_id, p_business_group_id,p_run_date);
1875: else

Line 1889: p_ret_business_group := hr_general.decode_organization(p_business_group_id);

1885: else
1886: p_ret_per_sel_rule := l_none;
1887: end if;
1888: --
1889: p_ret_business_group := hr_general.decode_organization(p_business_group_id);
1890: --
1891: if p_organization_id is not null then
1892: p_ret_organization := hr_general.decode_organization(p_organization_id);
1893: else

Line 1892: p_ret_organization := hr_general.decode_organization(p_organization_id);

1888: --
1889: p_ret_business_group := hr_general.decode_organization(p_business_group_id);
1890: --
1891: if p_organization_id is not null then
1892: p_ret_organization := hr_general.decode_organization(p_organization_id);
1893: else
1894: p_ret_organization := l_all;
1895: end if;
1896: --

Line 1898: p_ret_location := hr_general.decode_location(p_location_id);

1894: p_ret_organization := l_all;
1895: end if;
1896: --
1897: if p_location_id is not null then
1898: p_ret_location := hr_general.decode_location(p_location_id);
1899: else
1900: p_ret_location := l_all;
1901: end if;
1902: --

Line 1928: p_ret_prem_type := hr_general.decode_lookup('BEN_PRSPCTV_R_RTSPCTV',p_prem_type);

1924: p_ret_payroll := l_all;
1925: end if;
1926: --
1927: if p_prem_type is not null then
1928: p_ret_prem_type := hr_general.decode_lookup('BEN_PRSPCTV_R_RTSPCTV',p_prem_type);
1929: else
1930: p_ret_prem_type := l_all;
1931: end if;
1932: --

Line 1933: p_ret_output_typ := hr_general.decode_lookup('BEN_FILE_OP_TYP',p_output_typ);

1929: else
1930: p_ret_prem_type := l_all;
1931: end if;
1932: --
1933: p_ret_output_typ := hr_general.decode_lookup('BEN_FILE_OP_TYP',p_output_typ);
1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);
1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);
1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);
1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);

Line 1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);

1930: p_ret_prem_type := l_all;
1931: end if;
1932: --
1933: p_ret_output_typ := hr_general.decode_lookup('BEN_FILE_OP_TYP',p_output_typ);
1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);
1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);
1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);
1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);
1938: p_ret_dsply_lfe_rep := hr_general.decode_lookup('YES_NO',p_dsply_lfe_rep);

Line 1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);

1931: end if;
1932: --
1933: p_ret_output_typ := hr_general.decode_lookup('BEN_FILE_OP_TYP',p_output_typ);
1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);
1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);
1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);
1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);
1938: p_ret_dsply_lfe_rep := hr_general.decode_lookup('YES_NO',p_dsply_lfe_rep);
1939: --

Line 1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);

1932: --
1933: p_ret_output_typ := hr_general.decode_lookup('BEN_FILE_OP_TYP',p_output_typ);
1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);
1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);
1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);
1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);
1938: p_ret_dsply_lfe_rep := hr_general.decode_lookup('YES_NO',p_dsply_lfe_rep);
1939: --
1940: END report_header;

Line 1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);

1933: p_ret_output_typ := hr_general.decode_lookup('BEN_FILE_OP_TYP',p_output_typ);
1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);
1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);
1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);
1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);
1938: p_ret_dsply_lfe_rep := hr_general.decode_lookup('YES_NO',p_dsply_lfe_rep);
1939: --
1940: END report_header;
1941: --

Line 1938: p_ret_dsply_lfe_rep := hr_general.decode_lookup('YES_NO',p_dsply_lfe_rep);

1934: p_ret_dsply_pl_disc_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_disc_rep);
1935: p_ret_dsply_pl_recn_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_recn_rep);
1936: p_ret_dsply_pl_prtt_rep := hr_general.decode_lookup('YES_NO',p_dsply_pl_prtt_rep);
1937: p_ret_dsply_prtt_reps := hr_general.decode_lookup('YES_NO',p_dsply_prtt_reps);
1938: p_ret_dsply_lfe_rep := hr_general.decode_lookup('YES_NO',p_dsply_lfe_rep);
1939: --
1940: END report_header;
1941: --
1942: end ben_recn_rep;