APPS.PAY_PROCESSING_RULE_DATA_PUMP dependencies on HR_API

Line 47: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =

43: and et_tl.element_name = p_element_name
44: and p_effective_date between et.effective_start_date and
45: et.effective_end_date
46: and nvl(legislation_code,
47: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
48: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
49: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
50: nvl(p_business_group_id,-1)
51: and et_tl.language = p_language_code;

Line 48: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

44: and p_effective_date between et.effective_start_date and
45: et.effective_end_date
46: and nvl(legislation_code,
47: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
48: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
49: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
50: nvl(p_business_group_id,-1)
51: and et_tl.language = p_language_code;
52: --

Line 81: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =

77: Where f2.formula_type_id = f1.formula_type_id
78: and f2.formula_type_name in('Oracle Payroll' , 'Balance Adjustment')
79: and UPPER(f1.formula_name) = UPPER(p_formula_Name)
80: and nvl(f1.legislation_code,
81: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
82: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
83: and nvl(f1.business_group_id,nvl(p_business_group_id,-1)) =
84: nvl(p_business_group_id,-1) ;
85:

Line 82: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

78: and f2.formula_type_name in('Oracle Payroll' , 'Balance Adjustment')
79: and UPPER(f1.formula_name) = UPPER(p_formula_Name)
80: and nvl(f1.legislation_code,
81: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
82: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
83: and nvl(f1.business_group_id,nvl(p_business_group_id,-1)) =
84: nvl(p_business_group_id,-1) ;
85:
86:

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

150: and UPPER(astpl.user_status) = UPPER(p_assignment_status)
151: and nvl(astp.business_group_id,nvl(p_business_group_id,0))
152: = nvl(p_business_group_id,0)
153: and nvl(astp.legislation_code
154: ,nvl(hr_api.return_legislation_code(p_business_group_id),' '))
155: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
156: --
157: return(l_ass_status_typ_id);
158: end if;

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

151: and nvl(astp.business_group_id,nvl(p_business_group_id,0))
152: = nvl(p_business_group_id,0)
153: and nvl(astp.legislation_code
154: ,nvl(hr_api.return_legislation_code(p_business_group_id),' '))
155: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
156: --
157: return(l_ass_status_typ_id);
158: end if;
159: --