APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 301: per_assignments_f paf1,

297: cursor sqwl_employee_jurisdiction is
298: Select distinct
299: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
300: from pay_us_emp_city_tax_rules_f pcty,
301: per_assignments_f paf1,
302: per_assignments_f paf
303: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
304: and paf.effective_end_date >=
305: to_date('01-01-2001','DD-MM-YYYY')

Line 302: per_assignments_f paf

298: Select distinct
299: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
300: from pay_us_emp_city_tax_rules_f pcty,
301: per_assignments_f paf1,
302: per_assignments_f paf
303: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
304: and paf.effective_end_date >=
305: to_date('01-01-2001','DD-MM-YYYY')
306: and paf.effective_start_date <=

Line 331: per_assignments_f paf1,

327: /* commented for bug 2852640
328: Select distinct
329: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
330: from pay_us_emp_city_tax_rules_f pcty,
331: per_assignments_f paf1,
332: per_assignments_f paf
333: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
334: and paf.effective_end_date >= (
335: select

Line 332: per_assignments_f paf

328: Select distinct
329: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
330: from pay_us_emp_city_tax_rules_f pcty,
331: per_assignments_f paf1,
332: per_assignments_f paf
333: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
334: and paf.effective_end_date >= (
335: select
336: decode(

Line 502: from per_assignments_f paf2

498: */
499: /* Added for bug 2464463 */
500: AND SS.effective_start_date =
501: (select max(paf2.effective_start_date)
502: from per_assignments_f paf2
503: where paf2.assignment_id = SS.assignment_id
504: and paf2.effective_start_date <= PA.effective_date
505: and paf2.assignment_type = 'E')
506: AND SS.effective_end_date >= PA.start_date