[Home] [Help]
182: NOTES
183: Transfer to GL flag
184: -------------------
185: The Transfer to GL flag is a check box on the element link screen, and
186: held on the table pay_element_links_f. In release 9 this flag used to be
187: copied down to the costing table. However, this creates problems if the
188: user subsequently goes back and modifies the flag. So, for release 10,
189: it is only held on the link table. The SQL needed to track back to the
190: element link table from pay_run_results is very similar to the SQL for the
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'')
583: and RR2.source_id = EE1.element_entry_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'')
601: and least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
612: FROM pay_run_results RR1,
613: per_all_assignments_f PERA,
614: pay_element_types_f ET1,
615: pay_element_classifications EC,
616: pay_element_links_f EL1
617: WHERE RR1.assignment_action_id = pa2.assignment_action_id
618: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
619: CST.run_result_id)
620: AND (
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'')
787: and RR2.source_id = EE1.element_entry_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'')
805: and least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
816: FROM pay_run_results RR1,
817: per_all_assignments_f PERA,
818: pay_element_types_f ET1,
819: pay_element_classifications EC,
820: pay_element_links_f EL1
821: WHERE RR1.assignment_action_id = pa2.assignment_action_id
822: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
823: CST.run_result_id)
824: AND (
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'
1661: and RR2.source_id = EE1.element_entry_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)
1680: = EE1.element_entry_id
1692: select /*+ ORDERED */
1693: RR1.run_result_id
1694: FROM pay_run_results RR1,
1695: pay_element_types_f ET1,
1696: pay_element_links_f EL1,
1697: per_all_assignments_f PERA
1698: WHERE RR1.assignment_action_id = raa.assignment_action_id
1699: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
1700: CST.run_result_id)
1855: AND EXISTS
1856: (select /*+ ORDERED */
1857: 1
1858: FROM per_all_assignments_f PERA,
1859: pay_element_links_f EL1
1860: WHERE EL1.element_type_id = ET.element_type_id
1861: AND ppa.effective_date BETWEEN EL1.effective_start_date
1862: AND EL1.effective_end_date
1863: AND EL1.costable_type <> 'N'