APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 4609: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;
4607: l_comment_id per_assignments_f.comment_id%TYPE;
4608: l_legislation_code per_business_groups.legislation_code%TYPE;
4609: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4610: l_no_managers_warning boolean;
4611: l_other_manager_warning boolean;
4612: l_hourly_salaried_warning boolean;
4613: l_payroll_id_updated boolean;

Line 4774: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;
4772: l_comment_id per_assignments_f.comment_id%TYPE;
4773: l_legislation_code per_business_groups.legislation_code%TYPE;
4774: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4775: l_no_managers_warning boolean;
4776: l_other_manager_warning boolean;
4777: l_hourly_salaried_warning boolean;
4778: l_payroll_id_updated boolean;

Line 5744: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;
5743: l_legislation_code per_business_groups.legislation_code%TYPE;
5744: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5745: l_no_managers_warning boolean;
5746: l_other_manager_warning boolean;
5747: l_payroll_id_updated boolean;
5748: l_org_now_no_manager_warning boolean;

Line 5770: from per_assignment_status_types ast

5766: and bus.business_group_id+0 = asg.business_group_id;
5767: --
5768: cursor csr_get_asg_status_type is
5769: select ast.per_system_status
5770: from per_assignment_status_types ast
5771: where ast.assignment_status_type_id = p_assignment_status_type_id;
5772: --
5773: begin
5774: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 6097: from per_assignment_status_types

6093: l_legislation_code per_business_groups.legislation_code%TYPE; --added for bug 6917728
6094: --
6095: cursor csr_ass_sys_type is
6096: select per_system_status
6097: from per_assignment_status_types
6098: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
6099: --
6100: cursor csr_ass_step_sequence is
6101: select sequence

Line 6416: from per_assignment_status_types

6412: l_appl_cost_warning boolean;
6413: --
6414: cursor csr_ass_sys_type is
6415: select per_system_status
6416: from per_assignment_status_types
6417: where assignment_status_type_id = p_rec.assignment_status_type_id;
6418: --
6419: l_proc varchar2(72) := g_package||'post_delete';
6420: --