APPS.PAY_BALANCE_TYPES_DATA_PUMP dependencies on HR_API

Line 40: and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))

36: from pay_balance_categories_f
37: where category_name = p_category_name
38: and nvl(business_group_id, nvl(p_business_group_id,-1))
39: = nvl(p_business_group_id,-1)
40: and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
41: = nvl(hr_api.return_legislation_code(p_business_group_id),' ')
42: and p_effective_date between effective_start_date
43: and effective_end_date;
44:

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

37: where category_name = p_category_name
38: and nvl(business_group_id, nvl(p_business_group_id,-1))
39: = nvl(p_business_group_id,-1)
40: and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
41: = nvl(hr_api.return_legislation_code(p_business_group_id),' ')
42: and p_effective_date between effective_start_date
43: and effective_end_date;
44:
45: --

Line 74: and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))

70: where base_balance_type_id is null
71: and balance_name = p_base_balance_name
72: and nvl(business_group_id, nvl(p_business_group_id,-1))
73: = nvl(p_business_group_id,-1)
74: and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
75: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
76:
77: RETURN(l_balance_type_id);
78:

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

71: and balance_name = p_base_balance_name
72: and nvl(business_group_id, nvl(p_business_group_id,-1))
73: = nvl(p_business_group_id,-1)
74: and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
75: = nvl(hr_api.return_legislation_code(p_business_group_id),' ');
76:
77: RETURN(l_balance_type_id);
78:
79: Exception