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

Line 178: FROM per_all_assignments_f

174: CURSOR csr_get_asg_details IS
175: SELECT location_id,
176: soft_coding_keyflex_id,
177: business_group_id
178: FROM per_all_assignments_f
179: WHERE assignment_id = p_assignment_id
180: AND p_effective_date BETWEEN effective_start_date
181: AND effective_end_date;
182:

Line 187: FROM per_all_assignments_f

183: CURSOR csr_get_asg_details_ptu IS -- Bug:9753792
184: SELECT location_id,
185: soft_coding_keyflex_id,
186: business_group_id
187: FROM per_all_assignments_f
188: WHERE assignment_id = p_assignment_id
189: AND effective_start_date <= g_ptu_end_date
190: AND effective_end_date >= g_ptu_start_date;
191:

Line 192: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

188: WHERE assignment_id = p_assignment_id
189: AND effective_start_date <= g_ptu_end_date
190: AND effective_end_date >= g_ptu_start_date;
191:
192: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
193: l_location_id per_all_assignments_f.location_id%TYPE;
194: l_bg_id per_all_assignments_f.business_group_id%TYPE;
195: l_ppa_eff_date DATE;
196: l_ambiguous_flag BOOLEAN;

Line 193: l_location_id per_all_assignments_f.location_id%TYPE;

189: AND effective_start_date <= g_ptu_end_date
190: AND effective_end_date >= g_ptu_start_date;
191:
192: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
193: l_location_id per_all_assignments_f.location_id%TYPE;
194: l_bg_id per_all_assignments_f.business_group_id%TYPE;
195: l_ppa_eff_date DATE;
196: l_ambiguous_flag BOOLEAN;
197: l_missing_flag BOOLEAN;

Line 194: l_bg_id per_all_assignments_f.business_group_id%TYPE;

190: AND effective_end_date >= g_ptu_start_date;
191:
192: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
193: l_location_id per_all_assignments_f.location_id%TYPE;
194: l_bg_id per_all_assignments_f.business_group_id%TYPE;
195: l_ppa_eff_date DATE;
196: l_ambiguous_flag BOOLEAN;
197: l_missing_flag BOOLEAN;
198:

Line 238: ,per_all_assignments_f paf

234:
235: CURSOR csr_get_jd (cp_assignment_action_id NUMBER) IS
236: SELECT hl.region_1
237: FROM hr_locations_all hl
238: ,per_all_assignments_f paf
239: ,pay_assignment_actions paa
240: ,fnd_sessions fs
241: WHERE paa.assignment_action_id = cp_assignment_action_id
242: AND fs.session_id = userenv('sessionid')