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 183: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

179: WHERE assignment_id = p_assignment_id
180: AND p_effective_date BETWEEN effective_start_date
181: AND effective_end_date;
182:
183: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
184: l_location_id per_all_assignments_f.location_id%TYPE;
185: l_bg_id per_all_assignments_f.business_group_id%TYPE;
186: l_ppa_eff_date DATE;
187: l_ambiguous_flag BOOLEAN;

Line 184: l_location_id per_all_assignments_f.location_id%TYPE;

180: AND p_effective_date BETWEEN effective_start_date
181: AND effective_end_date;
182:
183: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
184: l_location_id per_all_assignments_f.location_id%TYPE;
185: l_bg_id per_all_assignments_f.business_group_id%TYPE;
186: l_ppa_eff_date DATE;
187: l_ambiguous_flag BOOLEAN;
188: l_missing_flag BOOLEAN;

Line 185: l_bg_id per_all_assignments_f.business_group_id%TYPE;

181: AND effective_end_date;
182:
183: l_hsck_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
184: l_location_id per_all_assignments_f.location_id%TYPE;
185: l_bg_id per_all_assignments_f.business_group_id%TYPE;
186: l_ppa_eff_date DATE;
187: l_ambiguous_flag BOOLEAN;
188: l_missing_flag BOOLEAN;
189:

Line 219: ,per_all_assignments_f paf

215:
216: CURSOR csr_get_jd (cp_assignment_action_id NUMBER) IS
217: SELECT hl.region_1
218: FROM hr_locations_all hl
219: ,per_all_assignments_f paf
220: ,pay_assignment_actions paa
221: ,fnd_sessions fs
222: WHERE paa.assignment_action_id = cp_assignment_action_id
223: AND fs.session_id = userenv('sessionid')