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.GHR_BEN_VALIDATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 63: from per_all_assignments_f pasf1, per_all_assignments_f pasf2

59:
60: --check if this person is rehired
61: Cursor c_chk_if_rehire (num_of_days number) is
62: select 'Y'
63: from per_all_assignments_f pasf1, per_all_assignments_f pasf2
64: where pasf2.person_id = pasf1.person_id
65: AND pasf2.assignment_id = p_assignment_id
66: AND p_effective_date between pasf2.effective_start_date and pasf2.effective_end_date
67: and (p_effective_date - num_of_days) between pasf1.effective_start_date and pasf1.effective_end_date

Line 80: from per_all_assignments_f asg

76: l_nte_date ghr_pa_requests.first_noa_information1%type;
77:
78: cursor cur_asg_prior_date( p_assignment_id in number) is
79: Select asg.effective_start_date
80: from per_all_assignments_f asg
81: Where asg.assignment_id = p_assignment_id
82: and asg.primary_flag = 'Y'
83: and asg.assignment_type <> 'B'
84: order by asg.effective_start_date;

Line 99: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,

95: l_business_group_id per_all_people_f.business_group_id%type;
96: l_element_type_id pay_element_types_f.element_type_id%type;
97: l_exists BOOLEAN;
98:
99: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,
100: c_effective_date per_all_assignments_f.effective_start_date%type,
101: c_element_type_id pay_element_types_f.element_type_id%type)
102: IS
103: SELECT 1

Line 100: c_effective_date per_all_assignments_f.effective_start_date%type,

96: l_element_type_id pay_element_types_f.element_type_id%type;
97: l_exists BOOLEAN;
98:
99: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,
100: c_effective_date per_all_assignments_f.effective_start_date%type,
101: c_element_type_id pay_element_types_f.element_type_id%type)
102: IS
103: SELECT 1
104: FROM pay_element_entries_f ele

Line 111: c_effective_date per_all_assignments_f.effective_start_date%type)

107: AND element_type_id = c_element_type_id;
108:
109: CURSOR c_element_type_id (c_element_name pay_element_types_f.element_name%type,
110: c_business_group_id pay_element_links_f.business_group_id%type,
111: c_effective_date per_all_assignments_f.effective_start_date%type)
112: IS
113: SELECT elt.element_type_id
114: FROM pay_element_links eli, pay_element_types_f elt
115: WHERE elt.element_type_id = eli.element_type_id

Line 768: c_assignment_id per_all_assignments_f.assignment_id%type,

764:
765:
766: --Bug #12553476 Modified c_element cursor to map the effective date comparison
767: CURSOR c_element(c_element_name pay_element_types_f.element_name%type,
768: c_assignment_id per_all_assignments_f.assignment_id%type,
769: c_effective_date pay_element_entries_f.effective_start_date%type,
770: c_business_group_id pay_element_links_f.business_group_id%type
771: ) is
772: SELECT a.element_name element_name,

Line 803: CURSOR c_get_person_id(c_assignment_id per_all_assignments_f.assignment_id%type,

799: and e.assignment_id = c_assignment_id
800: and a.element_name = c_element_name
801: AND c_effective_date BETWEEN e.effective_start_date AND e.effective_end_date;
802:
803: CURSOR c_get_person_id(c_assignment_id per_all_assignments_f.assignment_id%type,
804: c_effective_date per_all_assignments_f.effective_start_date%type)
805: IS
806: SELECT person_id
807: FROM per_all_assignments_f asg

Line 804: c_effective_date per_all_assignments_f.effective_start_date%type)

800: and a.element_name = c_element_name
801: AND c_effective_date BETWEEN e.effective_start_date AND e.effective_end_date;
802:
803: CURSOR c_get_person_id(c_assignment_id per_all_assignments_f.assignment_id%type,
804: c_effective_date per_all_assignments_f.effective_start_date%type)
805: IS
806: SELECT person_id
807: FROM per_all_assignments_f asg
808: WHERE asg.assignment_id = c_assignment_id

Line 807: FROM per_all_assignments_f asg

803: CURSOR c_get_person_id(c_assignment_id per_all_assignments_f.assignment_id%type,
804: c_effective_date per_all_assignments_f.effective_start_date%type)
805: IS
806: SELECT person_id
807: FROM per_all_assignments_f asg
808: WHERE asg.assignment_id = c_assignment_id
809: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
810:
811: CURSOR c_element_name(c_element_link_id pay_element_links_f.element_link_id%type,

Line 1202: FROM per_all_assignments_f asg

1198: ) IS
1199: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,
1200: c_effective_date per_assignments_f.effective_start_date%type) IS
1201: SELECT assignment_type, assignment_id
1202: FROM per_all_assignments_f asg
1203: WHERE asg.person_id = c_person_id
1204: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1205:
1206: CURSOR c_sess_date(c_session_id fnd_sessions.session_id%type)

Line 1221: l_assignment_type per_all_assignments_f.assignment_type%type;

1217: AND ppei.information_type = c_information_type;
1218:
1219: l_effective_date fnd_sessions.effective_date%type;
1220: l_session_id fnd_sessions.session_id%type;
1221: l_assignment_type per_all_assignments_f.assignment_type%type;
1222: l_assignment_id per_all_assignments_f.assignment_id%type;
1223: l_agency_contrib_date date;
1224: l_emp_contrib_date date;
1225: l_fers_elig_exp_date date;

Line 1222: l_assignment_id per_all_assignments_f.assignment_id%type;

1218:
1219: l_effective_date fnd_sessions.effective_date%type;
1220: l_session_id fnd_sessions.session_id%type;
1221: l_assignment_type per_all_assignments_f.assignment_type%type;
1222: l_assignment_id per_all_assignments_f.assignment_id%type;
1223: l_agency_contrib_date date;
1224: l_emp_contrib_date date;
1225: l_fers_elig_exp_date date;
1226: l_fegli_elig_exp_date date;