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

Line 6: l_mode hr_lookups.meaning%type ;

2: /* $Header: BENBOAUDB.pls 120.1 2007/12/10 08:24:12 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 ;
8: l_validate hr_lookups.meaning%type ;
9: l_person per_people_f.full_name%type ;
10: l_person_type per_person_types.user_person_type%type ;

Line 7: l_derivable_factors 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 ;
8: l_validate hr_lookups.meaning%type ;
9: l_person per_people_f.full_name%type ;
10: l_person_type per_person_types.user_person_type%type ;
11: l_program ben_pgm_f.name%type ;

Line 8: l_validate hr_lookups.meaning%type ;

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 ;
8: l_validate hr_lookups.meaning%type ;
9: l_person per_people_f.full_name%type ;
10: l_person_type per_person_types.user_person_type%type ;
11: l_program ben_pgm_f.name%type ;
12: l_business_group per_business_groups.name%type ;

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

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

Line 15: l_just_programs hr_lookups.meaning%type ;

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

Line 103: from ben_benefit_actions bft, hr_lookups hl

99: end;
100:
101: begin
102: select hl.meaning into CP_RESULTING_STATUS
103: from ben_benefit_actions bft, hr_lookups hl
104: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
105: and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
106: and bft.request_id = P_CONCURRENT_REQUEST_ID;
107: