APPS.PAY_US_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 202: from per_all_assignments_f assign,

198:
199: -- Cursor to get 'Work At Home' flag of current assignment.
200: cursor csr_wrk_at_home is
201: select assign.work_at_home
202: from per_all_assignments_f assign,
203: pay_assignment_actions paa
204: where paa.assignment_id = assign.assignment_id
205: and paa.assignment_action_id = p_asg_act_id
206: and assign.effective_start_date = (select max(paf.effective_start_date)

Line 207: from per_all_assignments_f paf

203: pay_assignment_actions paa
204: where paa.assignment_id = assign.assignment_id
205: and paa.assignment_action_id = p_asg_act_id
206: and assign.effective_start_date = (select max(paf.effective_start_date)
207: from per_all_assignments_f paf
208: where paf.assignment_id = assign.assignment_id);
209:
210: -- Cursor to get address information for the case when
211: -- person is working at home.

Line 218: per_all_assignments_f assign,

214: nvl(addr.add_information19,addr.region_1),
215: nvl(addr.add_information18,addr.town_or_city),
216: nvl(addr.add_information20,addr.postal_code)
217: from per_addresses addr,
218: per_all_assignments_f assign,
219: pay_assignment_actions paa
220: where paa.assignment_id = assign.assignment_id
221: and paa.assignment_action_id = p_asg_act_id
222: and addr.person_id = assign.person_id

Line 228: from per_all_assignments_f paf

224: and assign.effective_start_date
225: between nvl(addr.date_from, assign.effective_start_date)
226: and nvl(addr.date_to,assign.effective_start_date)
227: and assign.effective_start_date = (select max(paf.effective_start_date)
228: from per_all_assignments_f paf
229: where paf.assignment_id = assign.assignment_id);
230:
231:
232: -- Cursor to get address information for the case when

Line 241: per_all_assignments_f assign,

237: nvl(hrloc.loc_information18,hrloc.town_or_city),
238: nvl(hrloc.loc_information20,hrloc.postal_code)
239: from hr_locations hrloc,
240: hr_soft_coding_keyflex hrsckf,
241: per_all_assignments_f assign,
242: pay_assignment_actions paa
243: where paa.assignment_id = assign.assignment_id
244: and paa.assignment_action_id = p_asg_act_id
245: and assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id

Line 248: from per_all_assignments_f paf

244: and paa.assignment_action_id = p_asg_act_id
245: and assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id
246: and nvl(hrsckf.segment18,assign.location_id) = hrloc.location_id
247: and assign.effective_start_date = (select max(paf.effective_start_date)
248: from per_all_assignments_f paf
249: where paf.assignment_id = assign.assignment_id);
250:
251: l_asg_wrk_at_home varchar2(1);
252: l_ele_classification pay_element_classifications.classification_name%type;

Line 1902: per_all_assignments_f ASSIGN

1898: p_assignment_id number) IS
1899: SELECT target.SEGMENT4
1900: FROM /* route for SCL keyflex - assignment level */
1901: hr_soft_coding_keyflex target,
1902: per_all_assignments_f ASSIGN
1903: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
1904: AND ASSIGN.effective_end_date
1905: AND ASSIGN.assignment_id = p_assignment_id
1906: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id

Line 2233: per_all_assignments_f paa

2229: ,cp_assignment_id NUMBER) IS
2230: SELECT nvl(perj.JOB_INFORMATION3, 'EX')
2231: FROM per_jobs perj,
2232: per_jobs_tl perjtl,
2233: per_all_assignments_f paa
2234: WHERE cp_date_earned BETWEEN paa.effective_start_date AND paa.effective_end_date
2235: AND paa.assignment_id = cp_assignment_id
2236: AND paa.job_id = perj.job_id
2237: AND paa.job_id = perjtl.job_id

Line 2276: FROM per_all_assignments_f

2272: group id provided */
2273: CURSOR get_assignment_info(cp_assignment_id NUMBER
2274: ,cp_date DATE) IS
2275: SELECT person_id, payroll_id
2276: FROM per_all_assignments_f
2277: WHERE assignment_id = cp_assignment_id
2278: AND cp_date BETWEEN effective_start_date AND effective_end_date;
2279:
2280: -- Get time_definition_id corresponding to Overtime Week Id