[Home] [Help]
838: IS
839: SELECT NVL (SUM (hrw.hours), 0)
840: FROM hxt_det_hours_worked hrw, --C421
841: hxt_timecards tim,
842: hxt_earn_groups erg,
843: hxt_earn_group_types egt,
844: hxt_earning_policies erp
845: -- WHERE tim.id = a_tim_id
846: -- AND hrw.tim_id = a_tim_id
877: IS
878: SELECT NVL (SUM (hrw.hours), 0)
879: FROM hxt_det_hours_worked_f hrw,
880: hxt_timecards_f tim,
881: hxt_earn_groups erg,
882: hxt_earn_group_types egt,
883: hxt_earning_policies erp
884: WHERE tim.for_person_id = a_for_person_id
885: AND session_date between hrw.effective_start_date
913: IS
914: SELECT NVL (SUM (hrw.hours), 0)
915: FROM hxt_det_hours_worked_f hrw,
916: hxt_timecards_f tim,
917: hxt_earn_groups erg,
918: hxt_earn_group_types egt,
919: hxt_earning_policies erp
920: WHERE tim.id IN (p_tim_id, p_prev_id)
921: AND session_date between hrw.effective_start_date
1048: IS
1049: SELECT NVL (SUM (hrw.hours), 0)
1050: FROM hxt_det_hours_worked hrw, --C421
1051: hxt_timecards tim,
1052: hxt_earn_groups erg,
1053: hxt_earn_group_types egt,
1054: hxt_earning_policies erp
1055: -- WHERE tim.id = a_tim_id
1056: -- AND hrw.tim_id = a_tim_id
1089: IS
1090: SELECT NVL (SUM (hrw.hours), 0)
1091: FROM hxt_det_hours_worked_f hrw, --C421
1092: hxt_timecards_f tim,
1093: hxt_earn_groups erg,
1094: hxt_earn_group_types egt,
1095: hxt_earning_policies erp
1096: WHERE tim.for_person_id = a_for_person_id
1097: AND hrw.tim_id = tim.id
1124: IS
1125: SELECT NVL (SUM (hrw.hours), 0)
1126: FROM hxt_det_hours_worked_f hrw,
1127: hxt_timecards_f tim,
1128: hxt_earn_groups erg,
1129: hxt_earn_group_types egt,
1130: hxt_earning_policies erp
1131: WHERE tim.id IN (p_tim_id, p_prev_id)
1132: AND session_date between hrw.effective_start_date
1251: AND a_date_worked BETWEEN egt.effective_start_date
1252: AND egt.effective_end_date
1253: AND egt.id = a_earn_group
1254: AND EXISTS ( SELECT 'x'
1255: FROM hxt_earn_groups egr
1256: WHERE egr.egt_id = egt.id
1257: AND egr.element_type_id = a_element_type);
1258:
1259: IF returned_element = 1