[Home] [Help]
981: select 1 res
982: from sys.dual
983: where exists (
984: select /*+ index(AC2 PAY_ASSIGNMENT_ACTIONS_N51) */ null
985: from pay_action_classifications acl,
986: pay_assignment_actions ac2,
987: pay_payroll_actions pa2
988: where ac2.assignment_id = p_asg_id
989: and pa2.payroll_action_id = ac2.payroll_action_id
1036: select 1 res
1037: from sys.dual
1038: where exists (
1039: select null
1040: from pay_action_classifications acl,
1041: pay_assignment_actions ac2,
1042: pay_payroll_actions pa2
1043: where ac2.assignment_id = p_asg_id
1044: and pa2.payroll_action_id = ac2.payroll_action_id
1089: select 1 res
1090: from sys.dual
1091: where exists (
1092: select null
1093: from pay_action_classifications acl,
1094: pay_assignment_actions ac2,
1095: pay_payroll_actions pa2
1096: where ac2.assignment_id = p_asg_id
1097: and pa2.payroll_action_id = ac2.payroll_action_id
1141: select 1 res
1142: from sys.dual
1143: where exists (
1144: select null
1145: from pay_action_classifications acl,
1146: pay_assignment_actions ac2,
1147: pay_payroll_actions pa2
1148: where ac2.assignment_id = p_asg_id
1149: and pa2.payroll_action_id = ac2.payroll_action_id
1159: select 1 res
1160: from sys.dual
1161: where exists (
1162: select null
1163: from pay_action_classifications acl,
1164: pay_assignment_actions ac2,
1165: pay_payroll_actions pa2
1166: where ac2.assignment_id = p_asg_id
1167: and pa2.payroll_action_id = ac2.payroll_action_id
1175: select 1 res
1176: from sys.dual
1177: where exists (
1178: select null
1179: from pay_action_classifications acl,
1180: pay_assignment_actions ac2,
1181: pay_payroll_actions pa2
1182: where ac2.assignment_id = p_asg_id
1183: and pa2.payroll_action_id = ac2.payroll_action_id
2987: and pay_pac.effective_date between
2988: pay_asg.effective_start_date and pay_asg.effective_end_date
2989: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
2990: and exists (select null
2991: from pay_action_classifications pay_pcl,
2992: pay_assignment_actions pay_act,
2993: per_all_assignments_f pay_asg2,
2994: pay_payroll_actions pay_pac2
2995: where pay_pac2.consolidation_set_id +0 = pay_pac.consolidation_set_id
3278: and pay_inc.include_or_exclude = ''I''
3279: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3280: and pay_as2.rowid = pay_asg.rowid
3281: and exists (select null
3282: from pay_action_classifications pay_pcl,
3283: pay_assignment_actions pay_act,
3284: per_all_assignments_f pay_asg2,
3285: pay_payroll_actions pay_pac2
3286: where pay_pac2.consolidation_set_id +0 = pay_pac.consolidation_set_id
3465: -- this one is for time independent legislation.
3466: intind := '
3467: and not exists (
3468: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3469: from pay_action_classifications pay_acl,
3470: pay_payroll_actions pay_pa2,
3471: pay_assignment_actions pay_ac2
3472: where pay_ac2.assignment_id = pay_asg.assignment_id
3473: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3479: --
3480: intbal := '
3481: and not exists (
3482: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3483: from pay_action_classifications pay_acl,
3484: pay_payroll_actions pay_pa2,
3485: pay_assignment_actions pay_ac2
3486: where pay_ac2.assignment_id = pay_asg.assignment_id
3487: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3598: intretind := '
3599: and not exists (
3600: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */
3601: null
3602: from pay_action_classifications pay_acl,
3603: pay_payroll_actions pay_pa2,
3604: pay_assignment_actions pay_ac2
3605: where pay_ac2.assignment_id = pay_asg.assignment_id
3606: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id