DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 151: p_business_group_id in hr_organization_units.business_group_id%TYPE)

147: *
148: */
149: FUNCTION get_scheme_name(p_run_result_id in pay_run_results.run_result_id%TYPE,
150: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
151: p_business_group_id in hr_organization_units.business_group_id%TYPE)
152: RETURN VARCHAR2
153: IS
154:
155: -- Cursor to get all the valid scheme names for this

Line 162: from hr_organization_units hou,

158: CURSOR csr_scheme_names(c_business_group_id IN NUMBER)
159: IS
160: SELECT fnd_number.canonical_to_number(hoi.org_information20) scheme_id,
161: hoi.org_information2 scheme_name
162: from hr_organization_units hou,
163: hr_organization_information hoi
164: where hoi.org_information_context = 'HK_MPF_SCHEMES'
165: and hou.business_group_id = c_business_group_id
166: and hou.organization_id = hoi.organization_id;