DBA Data[Home] [Help]

APPS.BEN_BENLESUM_XMLP_PKG dependencies on HR_LOOKUPS

Line 16: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_REPT_MODL_CD' and lookup_code = p_report_module_cd;

12: CS_started_name_processed_comp in number, CS_proc_name_processed_comp in number,
13: CS_backedout_name_proc_comp in number, CS_voided_name_proc_comp in number, CS_total_name_proc_comp in number) return number is
14:
15: cursor c_report_module is
16: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_REPT_MODL_CD' and lookup_code = p_report_module_cd;
17:
18: cursor c_asg_type is
19: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_ASG_TYPE' and lookup_code = p_assignment_type;
20:

Line 19: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_ASG_TYPE' and lookup_code = p_assignment_type;

15: cursor c_report_module is
16: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_REPT_MODL_CD' and lookup_code = p_report_module_cd;
17:
18: cursor c_asg_type is
19: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_ASG_TYPE' and lookup_code = p_assignment_type;
20:
21: cursor c_ler_type is
22: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_LER_TYPE' and lookup_code = p_ler_type;
23:

Line 22: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_LER_TYPE' and lookup_code = p_ler_type;

18: cursor c_asg_type is
19: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_ASG_TYPE' and lookup_code = p_assignment_type;
20:
21: cursor c_ler_type is
22: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_LER_TYPE' and lookup_code = p_ler_type;
23:
24: cursor c_BG_info is
25: select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;
26:

Line 46: Select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_disp_flex_fields_flag;

42: cursor c_person_name is
43: Select full_name from per_all_people_f where person_id=p_person_id and business_group_id=p_business_group_id;
44:
45: cursor c_displ_flex is
46: Select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = p_disp_flex_fields_flag;
47:
48: begin
49:
50: CP_detected_name_potnl_rep :=CS_detected_name_potnl_rep;