35: -----------
36: Name Date Version Bug Text
37: -------------- ----------- ------- ------- -----------------------------
38: pracagra 02-Apr-2013 115.18 16521428 Added a date check on the table
39: pay_assignment_link_usages_f
40: tclewis 09-SEP-2011 115.17 Added code to check for a PSD
41: Jurisdiction code. PA ACT 32
42: required us to build a 16 character
43: jurisdiction code in the form of
549: pelf.people_group_id is null
550: or
551: exists (
552: select 1
553: from pay_assignment_link_usages_f usage
554: where usage.assignment_id = paf.assignment_id
555: and usage.element_link_id = pelf.element_link_id
556: /*Added for bug 16521428*/
557: and (
1473: pelf.people_group_id is null
1474: or
1475: exists (
1476: select 1
1477: from pay_assignment_link_usages_f usage
1478: where usage.assignment_id = paf.assignment_id
1479: and usage.element_link_id = pelf.element_link_id
1480: /*Added for bug 16521428*/
1481: and (