APPS.BEN_BENCMEPE_XMLP_PKG dependencies on HR_LOOKUPS

Line 6: l_mode hr_lookups.meaning%type ;

2: /* $Header: BENCMEPEB.pls 120.1 2007/12/10 08:27:36 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_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_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_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 ;

Line 17: l_cm_trgr_typ hr_lookups.meaning%type ;

13: l_person_selection_rule ff_formulas_f.formula_name%type ;
14: l_life_event_reason ben_ler_f.name%type ;
15: l_organization hr_all_organization_units.name%type ;
16: l_status fnd_lookups.meaning%type ;
17: l_cm_trgr_typ hr_lookups.meaning%type ;
18: l_cm_typ hr_lookups.meaning%type ;
19: l_plan_in_program hr_lookups.meaning%type ;
20: l_location hr_locations_all.description%type ;
21: l_actn_typ ben_actn_typ.name%type ;

Line 18: l_cm_typ hr_lookups.meaning%type ;

14: l_life_event_reason ben_ler_f.name%type ;
15: l_organization hr_all_organization_units.name%type ;
16: l_status fnd_lookups.meaning%type ;
17: l_cm_trgr_typ hr_lookups.meaning%type ;
18: l_cm_typ hr_lookups.meaning%type ;
19: l_plan_in_program hr_lookups.meaning%type ;
20: l_location hr_locations_all.description%type ;
21: l_actn_typ ben_actn_typ.name%type ;
22: l_elig_enrol hr_lookups.meaning%type ;

Line 19: l_plan_in_program hr_lookups.meaning%type ;

15: l_organization hr_all_organization_units.name%type ;
16: l_status fnd_lookups.meaning%type ;
17: l_cm_trgr_typ hr_lookups.meaning%type ;
18: l_cm_typ hr_lookups.meaning%type ;
19: l_plan_in_program hr_lookups.meaning%type ;
20: l_location hr_locations_all.description%type ;
21: l_actn_typ ben_actn_typ.name%type ;
22: l_elig_enrol hr_lookups.meaning%type ;
23: l_age_fctr ben_age_fctr.name%type ;

Line 22: l_elig_enrol hr_lookups.meaning%type ;

18: l_cm_typ hr_lookups.meaning%type ;
19: l_plan_in_program hr_lookups.meaning%type ;
20: l_location hr_locations_all.description%type ;
21: l_actn_typ ben_actn_typ.name%type ;
22: l_elig_enrol hr_lookups.meaning%type ;
23: l_age_fctr ben_age_fctr.name%type ;
24: l_min_age ben_benefit_actions.min_age%type ;
25: l_max_age ben_benefit_actions.max_age%type ;
26: l_los_fctr ben_los_fctr.name%type ;

Line 31: l_enrollment_period varchar2(800); l_audit_log hr_lookups.meaning%type ;

27: l_min_los ben_benefit_actions.min_los%type ;
28: l_max_los ben_benefit_actions.max_los%type ;
29: l_cmbn_age_los_fctr ben_cmbn_age_los_fctr.name%type ;
30: l_date_from ben_benefit_actions.date_from%type ;
31: l_enrollment_period varchar2(800); l_audit_log hr_lookups.meaning%type ;
32: begin
33:
34: ben_determine_communications.standard_header(
35: p_concurrent_request_id => p_concurrent_request_id,