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_BENBOSUM_XMLP_PKG dependencies on HR_LOOKUPS

Line 6: l_mode hr_lookups.meaning%type ;

2: /* $Header: BENBOSUMB.pls 120.1 2007/12/10 08:24:51 vjaganat noship $ */
3:
4: function CF_STANDARD_HEADERFormula return Number is
5: l_concurrent_program_name fnd_concurrent_programs_tl.user_concurrent_program_name%type ; l_process_date varchar2(30);
6: l_mode hr_lookups.meaning%type ;
7: l_derivable_factors hr_lookups.meaning%type ; l_validate hr_lookups.meaning%type ;
8: l_person per_people_f.full_name%type ;
9: l_person_type per_person_types.user_person_type%type ;
10: l_program ben_pgm_f.name%type ;

Line 7: l_derivable_factors hr_lookups.meaning%type ; l_validate hr_lookups.meaning%type ;

3:
4: function CF_STANDARD_HEADERFormula return Number is
5: l_concurrent_program_name fnd_concurrent_programs_tl.user_concurrent_program_name%type ; l_process_date varchar2(30);
6: l_mode hr_lookups.meaning%type ;
7: l_derivable_factors hr_lookups.meaning%type ; l_validate hr_lookups.meaning%type ;
8: l_person per_people_f.full_name%type ;
9: l_person_type per_person_types.user_person_type%type ;
10: l_program ben_pgm_f.name%type ;
11: l_business_group per_business_groups.name%type ; l_plan ben_pl_f.name%type ;

Line 12: l_enrollment_type_cycle varchar2(800); l_plans_not_in_programs hr_lookups.meaning%type ;

8: l_person per_people_f.full_name%type ;
9: l_person_type per_person_types.user_person_type%type ;
10: l_program ben_pgm_f.name%type ;
11: l_business_group per_business_groups.name%type ; l_plan ben_pl_f.name%type ;
12: l_enrollment_type_cycle varchar2(800); l_plans_not_in_programs hr_lookups.meaning%type ;
13: l_just_programs hr_lookups.meaning%type ; l_comp_object_selection_rule ff_formulas_f.formula_name%type ;
14: l_person_selection_rule ff_formulas_f.formula_name%type ;
15: l_life_event_reason ben_ler_f.name%type ;
16: l_organization hr_all_organization_units.name%type ; l_postal_zip_range varchar2(80);

Line 13: l_just_programs hr_lookups.meaning%type ; l_comp_object_selection_rule ff_formulas_f.formula_name%type ;

9: l_person_type per_person_types.user_person_type%type ;
10: l_program ben_pgm_f.name%type ;
11: l_business_group per_business_groups.name%type ; l_plan ben_pl_f.name%type ;
12: l_enrollment_type_cycle varchar2(800); l_plans_not_in_programs hr_lookups.meaning%type ;
13: l_just_programs hr_lookups.meaning%type ; l_comp_object_selection_rule ff_formulas_f.formula_name%type ;
14: l_person_selection_rule ff_formulas_f.formula_name%type ;
15: l_life_event_reason ben_ler_f.name%type ;
16: l_organization hr_all_organization_units.name%type ; l_postal_zip_range varchar2(80);
17: l_reporting_group ben_rptg_grp.name%type ;

Line 95: from ben_benefit_actions bft, hr_lookups hl

91: null;
92: end;
93: begin
94: select hl.meaning into CP_RESULTING_STATUS
95: from ben_benefit_actions bft, hr_lookups hl
96: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
97: and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
98: and bft.request_id = P_CONCURRENT_REQUEST_ID;
99: