APPS.PAY_FRR_DATA_PUMP dependencies on HR_API

Line 25: and et.legislation_code = hr_api.return_legislation_code(p_business_group_id)

21: pay_element_types_f_tl et_tl
22: where et_tl.element_name = p_element_name
23: and (et.business_group_id + 0 = p_business_group_id
24: or (et.business_group_id is null
25: and et.legislation_code = hr_api.return_legislation_code(p_business_group_id)
26: ))
27: and et_tl.element_type_id = et.element_type_id
28: and et_tl.language = p_language_code;
29: --

Line 69: ,nvl(hr_api.return_legislation_code(p_business_group_id),' '))

65: and asta.business_group_id(+) = p_business_group_id
66: and nvl(pas.business_group_id,nvl(p_business_group_id,0))
67: = nvl(p_business_group_id,0)
68: and nvl(pas.legislation_code
69: ,nvl(hr_api.return_legislation_code(p_business_group_id),' '))
70: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
71: --
72: End If;
73: --

Line 70: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');

66: and nvl(pas.business_group_id,nvl(p_business_group_id,0))
67: = nvl(p_business_group_id,0)
68: and nvl(pas.legislation_code
69: ,nvl(hr_api.return_legislation_code(p_business_group_id),' '))
70: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
71: --
72: End If;
73: --
74: return(l_ass_status_typ_id);

Line 121: and spr.legislation_code = hr_api.return_legislation_code(p_business_group_id)

117: and p_effective_date between spr.effective_start_date
118: and spr.effective_end_date
119: and (spr.business_group_id + 0 = p_business_group_id
120: or (spr.business_group_id is null
121: and spr.legislation_code = hr_api.return_legislation_code(p_business_group_id)
122: ))
123: and nvl(spr.assignment_status_type_id,-1) = nvl(l_ass_status_typ_id,-1);
124: --
125: return(l_spr_id);

Line 193: -- Specific parameters have HR_API defaults

189: or p_result_rule_type is null then
190: return null;
191: End If;
192: --
193: -- Specific parameters have HR_API defaults
194: --
195: If p_input_value_name = hr_api.g_varchar2 or p_source_element_name = hr_api.g_varchar2
196: or p_result_rule_type = hr_api.g_varchar2 then
197: return hr_api.g_number;

Line 195: If p_input_value_name = hr_api.g_varchar2 or p_source_element_name = hr_api.g_varchar2

191: End If;
192: --
193: -- Specific parameters have HR_API defaults
194: --
195: If p_input_value_name = hr_api.g_varchar2 or p_source_element_name = hr_api.g_varchar2
196: or p_result_rule_type = hr_api.g_varchar2 then
197: return hr_api.g_number;
198: End If;
199: --

Line 196: or p_result_rule_type = hr_api.g_varchar2 then

192: --
193: -- Specific parameters have HR_API defaults
194: --
195: If p_input_value_name = hr_api.g_varchar2 or p_source_element_name = hr_api.g_varchar2
196: or p_result_rule_type = hr_api.g_varchar2 then
197: return hr_api.g_number;
198: End If;
199: --
200: If p_result_rule_type = 'D' then

Line 197: return hr_api.g_number;

193: -- Specific parameters have HR_API defaults
194: --
195: If p_input_value_name = hr_api.g_varchar2 or p_source_element_name = hr_api.g_varchar2
196: or p_result_rule_type = hr_api.g_varchar2 then
197: return hr_api.g_number;
198: End If;
199: --
200: If p_result_rule_type = 'D' then
201: l_input_value_id := hr_pump_get.get_input_value_id

Line 211: Elsif p_element_name = hr_api.g_varchar2 then

207: );
208: Else
209: If p_element_name is null then
210: return null;
211: Elsif p_element_name = hr_api.g_varchar2 then
212: return hr_api.g_number;
213: Else
214: l_input_value_id := hr_pump_get.get_input_value_id
215: (p_input_value_name

Line 212: return hr_api.g_number;

208: Else
209: If p_element_name is null then
210: return null;
211: Elsif p_element_name = hr_api.g_varchar2 then
212: return hr_api.g_number;
213: Else
214: l_input_value_id := hr_pump_get.get_input_value_id
215: (p_input_value_name
216: ,p_element_name