DBA Data[Home] [Help]

APPS.PAY_KR_NPA_FUNC_PKG dependencies on HR_ORGANIZATION_UNITS

Line 8: p_business_group_id in hr_organization_units.organization_id%type,

4: -- get_bp_list: Get a comma separated list of business places
5: -- that report to the same National Pension office
6: -- in a business group
7: function get_bp_list(
8: p_business_group_id in hr_organization_units.organization_id%type,
9: p_bp_np_number in hr_organization_information.org_information1%type
10: ) return varchar2
11: is
12: cursor csr_bp_names is

Line 16: hr_organization_units hou,

12: cursor csr_bp_names is
13: select distinct
14: hou.name bp_name
15: from
16: hr_organization_units hou,
17: hr_organization_information npi
18: where
19: hou.business_group_id = p_business_group_id
20: and npi.organization_id = hou.organization_id