DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on HR_GENERAL

Line 56: ,hr_general.decode_lookup

52: ,paf.effective_start_date
53: ,paf.effective_end_date
54: ,'NO'
55: ,ast.user_status
56: ,hr_general.decode_lookup
57: ('EMP_CAT',
58: paf.employment_category) employment_category
59: ,paf.normal_hours
60: ,pps.date_start

Line 1997: ,Hr_General.decode_lookup('BEN_EXT_FRMT_MASK',

1993: ,b.ext_data_elmt_id
1994: ,b.data_elmt_typ_cd
1995: ,b.data_elmt_rl
1996: ,b.NAME
1997: ,Hr_General.decode_lookup('BEN_EXT_FRMT_MASK',
1998: b.frmt_mask_cd) frmt_mask_cd
1999: ,b.frmt_mask_cd frmt_mask_lookup_cd
2000: ,b.string_val
2001: ,b.dflt_val

Line 3767: g_conc_prog_details(0).reporting_options := HR_GENERAL.DECODE_LOOKUP

3763: hr_utility.set_location('l_location : '||l_location, 5);
3764: END IF;
3765:
3766: g_conc_prog_details(0).extract_name := l_extract_name;
3767: g_conc_prog_details(0).reporting_options := HR_GENERAL.DECODE_LOOKUP
3768: ('PQP_EXT_RPT_DIMENSION',
3769: p_reporting_dimension);
3770: g_conc_prog_details(0).selection_criteria := HR_GENERAL.DECODE_LOOKUP
3771: ('REPORT_SELECT_SORT_CODE',

Line 3770: g_conc_prog_details(0).selection_criteria := HR_GENERAL.DECODE_LOOKUP

3766: g_conc_prog_details(0).extract_name := l_extract_name;
3767: g_conc_prog_details(0).reporting_options := HR_GENERAL.DECODE_LOOKUP
3768: ('PQP_EXT_RPT_DIMENSION',
3769: p_reporting_dimension);
3770: g_conc_prog_details(0).selection_criteria := HR_GENERAL.DECODE_LOOKUP
3771: ('REPORT_SELECT_SORT_CODE',
3772: p_selection_criteria);
3773: g_conc_prog_details(0).elementset := l_element_set;
3774: g_conc_prog_details(0).elementname := l_element_name;