APPS.BEN_BENERPER_XMLP_PKG dependencies on HR_LOOKUPS

Line 6: l_mode hr_lookups.meaning%type ;

2: /* $Header: BENERPERB.pls 120.1 2007/12/10 08:31:45 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 15: l_plans_not_in_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);
15: l_plans_not_in_programs hr_lookups.meaning%type ;
16: l_just_programs hr_lookups.meaning%type ;
17: l_comp_object_selection_rule ff_formulas_f.formula_name%type ;
18: l_person_selection_rule ff_formulas_f.formula_name%type ;
19: l_life_event_reason ben_ler_f.name%type ;

Line 16: l_just_programs hr_lookups.meaning%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);
15: l_plans_not_in_programs hr_lookups.meaning%type ;
16: l_just_programs hr_lookups.meaning%type ;
17: l_comp_object_selection_rule ff_formulas_f.formula_name%type ;
18: l_person_selection_rule ff_formulas_f.formula_name%type ;
19: l_life_event_reason ben_ler_f.name%type ;
20: l_organization hr_all_organization_units.name%type ;

Line 31: l_location hr_locations_all.description%type ; l_audit_log hr_lookups.meaning%type ; l_benft_group ben_benfts_grp.name%type ; l_date_from varchar2(30);

27: l_legal_entity hr_all_organization_units.name%type ;
28: l_payroll pay_payrolls_f.payroll_name%type ;
29: l_status fnd_lookups.meaning%type ;
30: l_debug_message varchar2(80);
31: l_location hr_locations_all.description%type ; l_audit_log hr_lookups.meaning%type ; l_benft_group ben_benfts_grp.name%type ; l_date_from varchar2(30);
32:
33:
34: L01 varchar2(80); L02 varchar2(80); L03 varchar2(80); L04 varchar2(80); L05 varchar2(80);
35: L06 varchar2(80); L07 varchar2(80); L08 varchar2(80); L09 varchar2(80); L10 varchar2(80);

Line 115: from ben_benefit_actions bft, hr_lookups hl

111: null;
112: end;
113: begin
114: select hl.meaning into CP_BCKT_STAT_CD
115: from ben_benefit_actions bft, hr_lookups hl
116: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
117: and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
118: and bft.request_id = P_CONCURRENT_REQUEST_ID;
119: