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_OTHERBG_APL_API dependencies on PER_ALL_PEOPLE_F

Line 18: from per_all_people_f papf, per_all_assignments_f paaf

14: l_proc varchar2(72) := g_package||'close_application';
15:
16: cursor csr_person_id(l_apl_asg_id per_all_assignments_f.assignment_id%type,l_effective_date date) is
17: select papf.person_id,papf.object_version_number,papf.business_group_id,paaf.object_version_number
18: from per_all_people_f papf, per_all_assignments_f paaf
19: where paaf.assignment_id = l_apl_asg_id
20: and l_effective_date between nvl(paaf.effective_start_date,l_effective_date) and nvl(paaf.effective_end_date,l_effective_date)
21: and l_effective_date between nvl(papf.effective_start_date,l_effective_date) and nvl(papf.effective_end_date,l_effective_date)
22: and papf.person_id = paaf.person_id;

Line 62: l_object_version_number per_all_people_f.object_version_number%TYPE;

58: l_exists varchar2(1);
59: l_asg_max_end_date date;
60: l_person_id per_all_assignments_f.person_id%type;
61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;
62: l_object_version_number per_all_people_f.object_version_number%TYPE;
63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
66:

Line 63: l_business_group_id per_all_people_f.business_group_id%TYPE;

59: l_asg_max_end_date date;
60: l_person_id per_all_assignments_f.person_id%type;
61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;
62: l_object_version_number per_all_people_f.object_version_number%TYPE;
63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
66:
67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;

Line 70: t_effective_start_date per_all_people_f.effective_start_date%TYPE;

66:
67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;
68: i_object_version_number irc_assignment_statuses.object_version_number%type;
69:
70: t_effective_start_date per_all_people_f.effective_start_date%TYPE;
71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;
72: t_remove_fut_asg_warning BOOLEAN;
73:
74: a_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

Line 71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;

67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;
68: i_object_version_number irc_assignment_statuses.object_version_number%type;
69:
70: t_effective_start_date per_all_people_f.effective_start_date%TYPE;
71: t_effective_end_date per_all_people_f.effective_end_date%TYPE;
72: t_remove_fut_asg_warning BOOLEAN;
73:
74: a_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
75: a_effective_end_date per_all_assignments_f.effective_end_date%TYPE;