APPS.BEN_BENCLAUD_XMLP_PKG dependencies on HR_LOOKUPS

Line 6: l_mode hr_lookups.meaning%type ;

2: /* $Header: BENCLAUDB.pls 120.1 2007/12/10 08:25:44 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 ;

Line 14: l_plans_not_in_programs hr_lookups.meaning%type ;

10: l_program ben_pgm_f.name%type ;
11: l_business_group per_business_groups.name%type ;
12: l_plan ben_pl_f.name%type ;
13: l_enrollment_type_cycle varchar2(800);
14: 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 ;
17: l_person_selection_rule ff_formulas_f.formula_name%type ;
18: l_life_event_reason ben_ler_f.name%type ;

Line 15: l_just_programs hr_lookups.meaning%type ;

11: l_business_group per_business_groups.name%type ;
12: l_plan ben_pl_f.name%type ;
13: l_enrollment_type_cycle varchar2(800);
14: 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 ;
17: l_person_selection_rule ff_formulas_f.formula_name%type ;
18: l_life_event_reason ben_ler_f.name%type ;
19: l_organization hr_all_organization_units.name%type ;

Line 85: from hr_lookups a,

81: CP_LOCATION := l_all;
82: end;
83: begin
84: select meaning into CP_AUDIT_LOG
85: from hr_lookups a,
86: ben_benefit_actions b
87: where a.lookup_type = 'YES_NO'
88: and a.lookup_code = b.AUDIT_LOG_FLAG
89: and b.request_id = P_CONCURRENT_REQUEST_ID;

Line 96: from hr_lookups a,

92: null;
93: end;
94: begin
95: select meaning into CP_CLOSE_ACTION_ITEMS_FLAG
96: from hr_lookups a,
97: ben_benefit_actions b
98: where a.lookup_type = 'YES_NO'
99: and a.lookup_code = b.close_uneai_flag
100: and b.request_id = P_CONCURRENT_REQUEST_ID;

Line 123: from ben_benefit_actions bft, hr_lookups hl

119: null;
120: end;
121: begin
122: select hl.meaning into CP_CLOSE_MODE
123: from ben_benefit_actions bft, hr_lookups hl
124: where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
125: and hl.lookup_type = 'BEN_BENCLENR_MD'
126: and bft.request_id = P_CONCURRENT_REQUEST_ID;
127: