APPS.PAY_KW_PIFSS dependencies on FND_PROFILE

Line 75: ,decode(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),

71: ,'EMP_NO=P'
72: ,pef.employee_number
73: ,'EMP_NAME=P'
74: -- ,pef.full_name
75: ,decode(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),
76: 'L',
77: NVL(hr_person_name.get_person_name
78: (pef.person_id
79: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||

Line 82: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),

78: (pef.person_id
79: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||
80: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
81: ,'DISPLAY_NAME'
82: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
83: pef.full_name)
84: ,'EFFECTIVE_DATE=P'
85: ,to_char(ppa.effective_date,'YYYYMMDD')
86: ,'CHANGE_IND=P'

Line 132: ,decode(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),

128: ,'DED_EMP_NO=P'
129: ,pef.employee_number
130: ,'DED_EMP_NAME=P'
131: -- ,pef.full_name
132: ,decode(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),
133: 'L',
134: NVL(hr_person_name.get_person_name
135: (pef.person_id
136: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||

Line 139: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),

135: (pef.person_id
136: ,TRUNC(to_date('01'||'-'||pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Month')||'-'||
137: pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Year'),'dd-mm-yyyy'), 'MM')
138: ,'DISPLAY_NAME'
139: ,FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT')),' '),
140: pef.full_name)
141: ,'DED_DETAIL=P'
142: ,nvl(substr(pay_kw_pifss_report.get_deduction_detail(pay_kw_pifss_report.get_parameter(ppa1.legislative_parameters,'Report_Type'),paa.assignment_action_id,asg.assignment_id,ppa.effective_date),1,63),' ')
143: ,'DED_DETAIL2=P'