DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 6899: from hr_organization_information

6895: and loc.location_id = hou.location_id;
6896:
6897: cursor c_legislation (cp_business_group_id in number) is
6898: select org_information9
6899: from hr_organization_information
6900: where org_information_context = 'Business Group Information'
6901: and organization_id = cp_business_group_id;
6902:
6903: lv_procedure_name VARCHAR2(100) := '.get_3rdparty_check';

Line 7651: from hr_organization_information

7647: where paa.assignment_action_id = cp_assignment_action;
7648:
7649: cursor c_legislation (cp_business_group in number) is
7650: select org_information9
7651: from hr_organization_information
7652: where org_information_context = 'Business Group Information'
7653: and organization_id = cp_business_group;
7654:
7655: cursor c_sepchk_ryn_type is