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 3834: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

3830: --
3831: -- Out variables
3832: --
3833: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
3834: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3835: l_proc varchar2(72);
3836: --
3837: cursor csr_get_ast_details is
3838: select ast.per_system_status

Line 3840: from per_assignment_status_types ast

3836: --
3837: cursor csr_get_ast_details is
3838: select ast.per_system_status
3839: , ast.business_group_id
3840: from per_assignment_status_types ast
3841: where ast.assignment_status_type_id = p_assignment_status_type_id;
3842: --
3843: begin
3844: if g_debug then

Line 3964: l_active_flag per_assignment_status_types.active_flag%TYPE;

3960: l_exists varchar2(1);
3961: --
3962: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
3963: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
3964: l_active_flag per_assignment_status_types.active_flag%TYPE;
3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3968: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;

Line 3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;

3961: --
3962: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
3963: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
3964: l_active_flag per_assignment_status_types.active_flag%TYPE;
3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3968: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
3969: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

3963: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
3964: l_active_flag per_assignment_status_types.active_flag%TYPE;
3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3968: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
3969: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
3970: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
3971: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;

Line 3968: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;

3964: l_active_flag per_assignment_status_types.active_flag%TYPE;
3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3968: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
3969: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
3970: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
3971: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;
3972: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;

Line 3970: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;

3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
3968: l_ast_per_system_status per_assignment_status_types.per_system_status%TYPE;
3969: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
3970: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
3971: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;
3972: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;
3973: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;
3974: --

Line 3973: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;

3969: l_ast_business_group_id per_all_assignments_f.business_group_id%TYPE;
3970: l_old_per_system_status per_assignment_status_types.per_system_status%TYPE;
3971: l_initial_ins_date per_all_assignments_f.effective_start_date%TYPE;
3972: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;
3973: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;
3974: --
3975: -- Cursor to check that a assignment status type exists in
3976: -- PER_ASSIGNMENT_STATUS_TYPES.
3977: --

Line 3976: -- PER_ASSIGNMENT_STATUS_TYPES.

3972: l_apl_asg_min_esd per_all_assignments_f.effective_start_date%TYPE;
3973: l_fir_dt_ast_pss per_assignment_status_types.per_system_status%TYPE;
3974: --
3975: -- Cursor to check that a assignment status type exists in
3976: -- PER_ASSIGNMENT_STATUS_TYPES.
3977: --
3978: cursor csr_valid_ast is
3979: select legislation_code, active_flag, business_group_id, per_system_status
3980: from per_assignment_status_types

Line 3980: from per_assignment_status_types

3976: -- PER_ASSIGNMENT_STATUS_TYPES.
3977: --
3978: cursor csr_valid_ast is
3979: select legislation_code, active_flag, business_group_id, per_system_status
3980: from per_assignment_status_types
3981: where assignment_status_type_id = p_rec.assignment_status_type_id;
3982: --
3983: -- Cursor to retrieve the legislation code of the assignment's
3984: -- business group.

Line 4005: from per_assignment_status_types

4001: -- assignment status type of the assignment.
4002: --
4003: cursor csr_get_old_per_system_type is
4004: select per_system_status
4005: from per_assignment_status_types
4006: where assignment_status_type_id =
4007: per_asg_shd.g_old_rec.assignment_status_type_id;
4008: --
4009: -- Cursor to retrieve the effective start date of

Line 4016: ,per_assignment_status_types ast

4012: --
4013: cursor csr_get_initial_ins_date is
4014: select nvl(min(asg.effective_start_date), hr_api.g_eot)
4015: from per_all_assignments_f asg
4016: ,per_assignment_status_types ast
4017: where asg.assignment_id = p_rec.assignment_id
4018: and ast.assignment_status_type_id = asg.assignment_status_type_id
4019: and ast.per_system_status = 'ACTIVE_ASSIGN';
4020: --

Line 4038: ,per_assignment_status_types ast

4034: (c_effective_start_date per_all_assignments_f.effective_start_date%TYPE)
4035: is
4036: select ast.per_system_status
4037: from per_all_assignments_f asg
4038: ,per_assignment_status_types ast
4039: where asg.assignment_id = p_rec.assignment_id
4040: and asg.effective_start_date = c_effective_start_date
4041: and ast.assignment_status_type_id = asg.assignment_status_type_id;
4042: --

Line 4322: -- PER_ASSIGNMENT_STATUS_TYPES.

4318: hr_utility.set_location(l_proc, 30);
4319: end if;
4320: --
4321: -- Check if the assignment status type exists in
4322: -- PER_ASSIGNMENT_STATUS_TYPES.
4323: --
4324: open csr_valid_ast;
4325: fetch csr_valid_ast
4326: into l_ast_legislation_code

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

4386: fetch csr_chk_amends into l_active_flag, l_per_system_status;
4387: if csr_chk_amends%notfound then
4388: --
4389: -- Use active flag and business group values from
4390: -- PER_ASSIGNMENT_STATUS_TYPES for the assignment status type.
4391: --
4392: l_active_flag := l_ast_active_flag;
4393: l_per_system_status := l_ast_per_system_status;
4394: --

Line 7459: from per_all_assignments_f asg, per_assignment_status_types ast

7455: p_except_assignment_id number) return boolean is
7456: l_dummy varchar2(1);
7457: cursor c1 is
7458: select 'x'
7459: from per_all_assignments_f asg, per_assignment_status_types ast
7460: where position_id = p_position_id
7461: and assignment_id <> nvl(p_except_assignment_id, -1)
7462: and ( assignment_type = 'E' /*or assignment_type = 'A'*/) -- change for the bug 5854568(modified for 6331872)
7463: and p_effective_date between effective_start_date and effective_end_date