[Home] [Help]
574: AND EXISTS
575: (select RR1.run_result_id
576: from pay_run_results RR1
577: , pay_run_results RR2
578: , pay_element_entries_f EE1
579: , pay_element_links_f EL1
580: where RR1.assignment_action_id = pa2.assignment_action_id
581: and RR1.source_id = RR2.run_result_id
582: and RR1.source_type NOT IN (''E'', ''I'', ''V'')
592: CST.run_result_id)
593: UNION ALL
594: select RR1.run_result_id
595: from pay_run_results RR1
596: , pay_element_entries_f EE1
597: , pay_element_links_f EL1
598: where RR1.assignment_action_id = pa2.assignment_action_id
599: and RR1.source_id = EE1.element_entry_id
600: and RR1.source_type NOT IN (''R'', ''I'', ''V'')
619: CST.run_result_id)
620: AND (
621: (NOT EXISTS /* look for deleted element entries */
622: (SELECT null
623: FROM pay_element_entries_f EE1
624: WHERE RR1.source_id = EE1.element_entry_id
625: AND RR1.source_type IN (''E'', ''I'')
626: AND least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
627: BETWEEN EE1.effective_start_date
629: )
630: AND NOT EXISTS
631: (SELECT null
632: FROM pay_run_results RR2,
633: pay_element_entries_f EE1
634: WHERE RR2.source_id = EE1.element_entry_id
635: AND RR1.source_type IN (''R'', ''V'')
636: AND RR1.source_id = RR2.run_result_id
637: AND least(nvl(RR2.end_date, ppa.date_earned), ppa.date_earned)
778: AND EXISTS
779: (select RR1.run_result_id
780: from pay_run_results RR1
781: , pay_run_results RR2
782: , pay_element_entries_f EE1
783: , pay_element_links_f EL1
784: where RR1.assignment_action_id = pa2.assignment_action_id
785: and RR1.source_id = RR2.run_result_id
786: and RR1.source_type NOT IN (''E'', ''I'', ''V'')
796: CST.run_result_id)
797: UNION ALL
798: select RR1.run_result_id
799: from pay_run_results RR1
800: , pay_element_entries_f EE1
801: , pay_element_links_f EL1
802: where RR1.assignment_action_id = pa2.assignment_action_id
803: and RR1.source_id = EE1.element_entry_id
804: and RR1.source_type NOT IN (''R'', ''I'', ''V'')
823: CST.run_result_id)
824: AND (
825: (NOT EXISTS /* look for deleted element entries */
826: (SELECT null
827: FROM pay_element_entries_f EE1
828: WHERE RR1.source_id = EE1.element_entry_id
829: AND RR1.source_type IN (''E'', ''I'')
830: AND least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
831: BETWEEN EE1.effective_start_date
833: )
834: AND NOT EXISTS
835: (SELECT null
836: FROM pay_run_results RR2,
837: pay_element_entries_f EE1
838: WHERE RR2.source_id = EE1.element_entry_id
839: AND RR1.source_type IN (''R'', ''V'')
840: AND RR1.source_id = RR2.run_result_id
841: AND least(nvl(RR2.end_date, ppa.date_earned), ppa.date_earned)
1652: AND EXISTS
1653: (select RR1.run_result_id
1654: from pay_run_results RR1
1655: , pay_run_results RR2
1656: , pay_element_entries_f EE1
1657: , pay_element_links_f EL1
1658: where RR1.assignment_action_id = raa.assignment_action_id
1659: and RR1.source_id = RR2.run_result_id
1660: and RR1.source_type = 'R'
1671: CST.run_result_id)
1672: UNION ALL
1673: select RR1.run_result_id
1674: from pay_run_results RR1
1675: , pay_element_entries_f EE1
1676: , pay_element_links_f EL1
1677: where RR1.assignment_action_id = raa.assignment_action_id
1678: and decode(r_action_type, 'B', nvl(RR1.element_entry_id, RR1.source_id),
1679: RR1.source_id)
1700: CST.run_result_id)
1701: AND (
1702: (NOT EXISTS /* look for deleted element entries */
1703: (SELECT null
1704: FROM pay_element_entries_f EE1
1705: WHERE RR1.source_id = EE1.element_entry_id
1706: AND RR1.source_type IN ('E', 'I')
1707: AND least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
1708: BETWEEN EE1.effective_start_date
1709: AND EE1.effective_end_date
1710: )
1711: AND NOT EXISTS
1712: (SELECT null
1713: FROM pay_element_entries_f EE1,
1714: pay_run_results RR2
1715: WHERE RR2.source_id = EE1.element_entry_id
1716: AND RR1.source_type IN ('R', 'V')
1717: AND RR1.source_id = RR2.run_result_id