APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 338: per_assignments_f paf1,

334: cursor sqwl_employee_jurisdiction is
335: Select distinct
336: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
337: from pay_us_emp_city_tax_rules_f pcty,
338: per_assignments_f paf1,
339: per_assignments_f paf
340: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
341: and paf.effective_end_date >=
342: to_date('01-01-2001','DD-MM-YYYY')

Line 339: per_assignments_f paf

335: Select distinct
336: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
337: from pay_us_emp_city_tax_rules_f pcty,
338: per_assignments_f paf1,
339: per_assignments_f paf
340: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
341: and paf.effective_end_date >=
342: to_date('01-01-2001','DD-MM-YYYY')
343: and paf.effective_start_date <=

Line 368: per_assignments_f paf1,

364: /* commented for bug 2852640
365: Select distinct
366: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
367: from pay_us_emp_city_tax_rules_f pcty,
368: per_assignments_f paf1,
369: per_assignments_f paf
370: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
371: and paf.effective_end_date >= (
372: select

Line 369: per_assignments_f paf

365: Select distinct
366: 'JURISDICTION_CODE=C', pcty.jurisdiction_code
367: from pay_us_emp_city_tax_rules_f pcty,
368: per_assignments_f paf1,
369: per_assignments_f paf
370: where paf.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
371: and paf.effective_end_date >= (
372: select
373: decode(

Line 541: from per_assignments_f paf2

537: */
538: /* Added for bug 2464463 */
539: AND SS.effective_start_date =
540: (select max(paf2.effective_start_date)
541: from per_assignments_f paf2
542: where paf2.assignment_id = SS.assignment_id
543: and paf2.effective_start_date <= PA.effective_date
544: and paf2.assignment_type = 'E')
545: AND SS.effective_end_date >= PA.start_date