[Home] [Help]
189: NOTES
190: Transfer to GL flag
191: -------------------
192: The Transfer to GL flag is a check box on the element link screen, and
193: held on the table pay_element_links_f. In release 9 this flag used to be
194: copied down to the costing table. However, this creates problems if the
195: user subsequently goes back and modifies the flag. So, for release 10,
196: it is only held on the link table. The SQL needed to track back to the
197: element link table from pay_run_results is very similar to the SQL for the
582: (select RR1.run_result_id
583: from pay_run_results RR1
584: , pay_run_results RR2
585: , pay_element_entries_f EE1
586: , pay_element_links_f EL1
587: where RR1.assignment_action_id = pa2.assignment_action_id
588: and RR1.source_id = RR2.run_result_id
589: and RR1.source_type NOT IN (''E'', ''I'', ''V'')
590: and RR2.source_id = EE1.element_entry_id
600: UNION ALL
601: select RR1.run_result_id
602: from pay_run_results RR1
603: , pay_element_entries_f EE1
604: , pay_element_links_f EL1
605: where RR1.assignment_action_id = pa2.assignment_action_id
606: and RR1.source_id = EE1.element_entry_id
607: and RR1.source_type NOT IN (''R'', ''I'', ''V'')
608: and least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
619: FROM pay_run_results RR1,
620: per_all_assignments_f PERA,
621: pay_element_types_f ET1,
622: pay_element_classifications EC,
623: pay_element_links_f EL1
624: WHERE RR1.assignment_action_id = pa2.assignment_action_id
625: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
626: CST.run_result_id)
627: AND (
786: (select RR1.run_result_id
787: from pay_run_results RR1
788: , pay_run_results RR2
789: , pay_element_entries_f EE1
790: , pay_element_links_f EL1
791: where RR1.assignment_action_id = pa2.assignment_action_id
792: and RR1.source_id = RR2.run_result_id
793: and RR1.source_type NOT IN (''E'', ''I'', ''V'')
794: and RR2.source_id = EE1.element_entry_id
804: UNION ALL
805: select RR1.run_result_id
806: from pay_run_results RR1
807: , pay_element_entries_f EE1
808: , pay_element_links_f EL1
809: where RR1.assignment_action_id = pa2.assignment_action_id
810: and RR1.source_id = EE1.element_entry_id
811: and RR1.source_type NOT IN (''R'', ''I'', ''V'')
812: and least(nvl(RR1.end_date, ppa.date_earned), ppa.date_earned)
823: FROM pay_run_results RR1,
824: per_all_assignments_f PERA,
825: pay_element_types_f ET1,
826: pay_element_classifications EC,
827: pay_element_links_f EL1
828: WHERE RR1.assignment_action_id = pa2.assignment_action_id
829: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
830: CST.run_result_id)
831: AND (
1672: (select RR1.run_result_id
1673: from pay_run_results RR1
1674: , pay_run_results RR2
1675: , pay_element_entries_f EE1
1676: , pay_element_links_f EL1
1677: where RR1.assignment_action_id = raa.assignment_action_id
1678: and RR1.source_id = RR2.run_result_id
1679: and RR1.source_type = 'R'
1680: and RR2.source_id = EE1.element_entry_id
1691: UNION ALL
1692: select RR1.run_result_id
1693: from pay_run_results RR1
1694: , pay_element_entries_f EE1
1695: , pay_element_links_f EL1
1696: where RR1.assignment_action_id = raa.assignment_action_id
1697: and decode(r_action_type, 'B', nvl(RR1.element_entry_id, RR1.source_id),
1698: RR1.source_id)
1699: = EE1.element_entry_id
1711: select /*+ ORDERED */
1712: RR1.run_result_id
1713: FROM pay_run_results RR1,
1714: pay_element_types_f ET1,
1715: pay_element_links_f EL1,
1716: per_all_assignments_f PERA
1717: WHERE RR1.assignment_action_id = raa.assignment_action_id
1718: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,
1719: CST.run_result_id)
1874: AND EXISTS
1875: (select /*+ ORDERED */
1876: 1
1877: FROM per_all_assignments_f PERA,
1878: pay_element_links_f EL1
1879: WHERE EL1.element_type_id = ET.element_type_id
1880: AND ppa.effective_date BETWEEN EL1.effective_start_date
1881: AND EL1.effective_end_date
1882: AND EL1.costable_type <> 'N'