APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 4742: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;
4740: l_comment_id per_assignments_f.comment_id%TYPE;
4741: l_legislation_code per_business_groups.legislation_code%TYPE;
4742: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4743: l_no_managers_warning boolean;
4744: l_other_manager_warning boolean;
4745: l_hourly_salaried_warning boolean;
4746: l_payroll_id_updated boolean;

Line 4907: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;
4905: l_comment_id per_assignments_f.comment_id%TYPE;
4906: l_legislation_code per_business_groups.legislation_code%TYPE;
4907: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4908: l_no_managers_warning boolean;
4909: l_other_manager_warning boolean;
4910: l_hourly_salaried_warning boolean;
4911: l_payroll_id_updated boolean;

Line 5879: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;
5878: l_legislation_code per_business_groups.legislation_code%TYPE;
5879: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5880: l_no_managers_warning boolean;
5881: l_other_manager_warning boolean;
5882: l_payroll_id_updated boolean;
5883: l_org_now_no_manager_warning boolean;

Line 5905: from per_assignment_status_types ast

5901: and bus.business_group_id+0 = asg.business_group_id;
5902: --
5903: cursor csr_get_asg_status_type is
5904: select ast.per_system_status
5905: from per_assignment_status_types ast
5906: where ast.assignment_status_type_id = p_assignment_status_type_id;
5907: --
5908:
5909: -- call to ethnicity 12858051

Line 5913: from per_assignment_status_types ast

5909: -- call to ethnicity 12858051
5910:
5911: cursor csr_asg_status_type is
5912: select ast.per_system_status
5913: from per_assignment_status_types ast
5914: where ast.assignment_status_type_id = p_assignment_status_type_id;
5915:
5916: cursor c_person_enthn is
5917: select person_id,business_group_id,per_information1

Line 6311: from per_assignment_status_types

6307: l_legislation_code per_business_groups.legislation_code%TYPE; --added for bug 6917728
6308: --
6309: cursor csr_ass_sys_type is
6310: select per_system_status
6311: from per_assignment_status_types
6312: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
6313: --
6314: cursor csr_ass_step_sequence is
6315: select sequence

Line 6634: from per_assignment_status_types

6630: l_appl_cost_warning boolean;
6631: --
6632: cursor csr_ass_sys_type is
6633: select per_system_status
6634: from per_assignment_status_types
6635: where assignment_status_type_id = p_rec.assignment_status_type_id;
6636: --
6637: l_proc varchar2(72) := g_package||'post_delete';
6638: --