eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASG_BUS1 dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 3956: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

3952: --
3953: -- Out variables
3954: --
3955: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
3956: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3957: l_proc varchar2(72);
3958: --
3959: cursor csr_get_ast_details is
3960: select ast.per_system_status

Line 3962: from per_assignment_status_types ast

3958: --
3959: cursor csr_get_ast_details is
3960: select ast.per_system_status
3961: , ast.business_group_id
3962: from per_assignment_status_types ast
3963: where ast.assignment_status_type_id = p_assignment_status_type_id;
3964: --
3965: begin
3966: if g_debug then

Line 4086: l_active_flag per_assignment_status_types.active_flag%TYPE;

4082: l_exists varchar2(1);
4083: --
4084: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
4085: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
4086: l_active_flag per_assignment_status_types.active_flag%TYPE;
4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4090: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;

4083: --
4084: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
4085: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
4086: l_active_flag per_assignment_status_types.active_flag%TYPE;
4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4090: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
4091: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

4085: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
4086: l_active_flag per_assignment_status_types.active_flag%TYPE;
4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4090: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
4091: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
4092: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
4093: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;

Line 4090: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;

4086: l_active_flag per_assignment_status_types.active_flag%TYPE;
4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4090: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
4091: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
4092: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
4093: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;
4094: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;

Line 4092: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;

4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4090: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
4091: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
4092: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
4093: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;
4094: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;
4095: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;
4096: --

Line 4095: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;

4091: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
4092: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
4093: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;
4094: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;
4095: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;
4096: --
4097: -- Cursor to check that a assignment status type exists in
4098: -- PER_ASSIGNMENT_STATUS_TYPES.
4099: --

Line 4098: -- PER_ASSIGNMENT_STATUS_TYPES.

4094: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;
4095: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;
4096: --
4097: -- Cursor to check that a assignment status type exists in
4098: -- PER_ASSIGNMENT_STATUS_TYPES.
4099: --
4100: cursor csr_valid_ast is
4101: select legislation_code, active_flag, business_group_id, per_system_status
4102: from per_assignment_status_types

Line 4102: from per_assignment_status_types

4098: -- PER_ASSIGNMENT_STATUS_TYPES.
4099: --
4100: cursor csr_valid_ast is
4101: select legislation_code, active_flag, business_group_id, per_system_status
4102: from per_assignment_status_types
4103: where assignment_status_type_id = p_rec.assignment_status_type_id;
4104: --
4105: -- Cursor to retrieve the legislation code of the assignment's
4106: -- business group.

Line 4127: from per_assignment_status_types

4123: -- assignment status type of the assignment.
4124: --
4125: cursor csr_get_old_per_system_type is
4126: select per_system_status
4127: from per_assignment_status_types
4128: where assignment_status_type_id =
4129: per_asg_shd.g_old_rec.assignment_status_type_id;
4130: --
4131: -- Cursor to retrieve the effective start date of

Line 4138: ,per_assignment_status_types ast

4134: --
4135: cursor csr_get_initial_ins_date is
4136: select nvl(min(asg.effective_start_date), hr_api.g_eot)
4137: from per_all_assignments_f asg
4138: ,per_assignment_status_types ast
4139: where asg.assignment_id = p_rec.assignment_id
4140: and ast.assignment_status_type_id = asg.assignment_status_type_id
4141: and ast.per_system_status = 'ACTIVE_ASSIGN';
4142: --

Line 4160: ,per_assignment_status_types ast

4156: (c_effective_start_date per_all_assignments_f.effective_start_date%TYPE)
4157: is
4158: select ast.per_system_status
4159: from per_all_assignments_f asg
4160: ,per_assignment_status_types ast
4161: where asg.assignment_id = p_rec.assignment_id
4162: and asg.effective_start_date = c_effective_start_date
4163: and ast.assignment_status_type_id = asg.assignment_status_type_id;
4164: --

Line 4448: -- PER_ASSIGNMENT_STATUS_TYPES.

4444: hr_utility.set_location(l_proc, 30);
4445: end if;
4446: --
4447: -- Check if the assignment status type exists in
4448: -- PER_ASSIGNMENT_STATUS_TYPES.
4449: --
4450: open csr_valid_ast;
4451: fetch csr_valid_ast
4452: into l_ast_legislation_code

Line 4516: -- PER_ASSIGNMENT_STATUS_TYPES for the assignment status type.

4512: fetch csr_chk_amends into l_active_flag, l_per_system_status;
4513: if csr_chk_amends%notfound then
4514: --
4515: -- Use active flag and business group values from
4516: -- PER_ASSIGNMENT_STATUS_TYPES for the assignment status type.
4517: --
4518: l_active_flag := l_ast_active_flag;
4519: l_per_system_status := l_ast_per_system_status;
4520: --

Line 7441: from per_all_assignments_f paaf, per_assignment_status_types past

7437: select
7438: paaf.assignment_number,
7439: paaf.effective_start_date,
7440: paaf.effective_end_date
7441: from per_all_assignments_f paaf, per_assignment_status_types past
7442: where paaf.assignment_status_type_id = past.assignment_status_type_id
7443: and paaf.assignment_type in ('E','C') -- Added For Bug#13860076
7444: --and paaf.assignment_type = 'E' -- Commented For Bug#13860076
7445: and past.per_system_status <> 'TERM_ASSIGN'

Line 7839: from per_all_assignments_f asg, per_assignment_status_types ast

7835: p_except_assignment_id number) return boolean is
7836: l_dummy varchar2(1);
7837: cursor c1 is
7838: select 'x'
7839: from per_all_assignments_f asg, per_assignment_status_types ast
7840: where position_id = p_position_id
7841: and assignment_id <> nvl(p_except_assignment_id, -1)
7842: and assignment_type in ('E','C') -- For Bug#13860076, commented below statement and added this condition
7843: --and ( assignment_type = 'E' /*or assignment_type = 'A'*/) -- change for the bug 5854568 (6332332)