976: select 1 res
977: from sys.dual
978: where exists (
979: select null
980: from pay_action_classifications acl,
981: pay_assignment_actions ac2,
982: pay_payroll_actions pa2
983: where ac2.assignment_id = p_asg_id
984: and pa2.payroll_action_id = ac2.payroll_action_id
1031: select 1 res
1032: from sys.dual
1033: where exists (
1034: select null
1035: from pay_action_classifications acl,
1036: pay_assignment_actions ac2,
1037: pay_payroll_actions pa2
1038: where ac2.assignment_id = p_asg_id
1039: and pa2.payroll_action_id = ac2.payroll_action_id
1084: select 1 res
1085: from sys.dual
1086: where exists (
1087: select null
1088: from pay_action_classifications acl,
1089: pay_assignment_actions ac2,
1090: pay_payroll_actions pa2
1091: where ac2.assignment_id = p_asg_id
1092: and pa2.payroll_action_id = ac2.payroll_action_id
1136: select 1 res
1137: from sys.dual
1138: where exists (
1139: select null
1140: from pay_action_classifications acl,
1141: pay_assignment_actions ac2,
1142: pay_payroll_actions pa2
1143: where ac2.assignment_id = p_asg_id
1144: and pa2.payroll_action_id = ac2.payroll_action_id
1154: select 1 res
1155: from sys.dual
1156: where exists (
1157: select null
1158: from pay_action_classifications acl,
1159: pay_assignment_actions ac2,
1160: pay_payroll_actions pa2
1161: where ac2.assignment_id = p_asg_id
1162: and pa2.payroll_action_id = ac2.payroll_action_id
1170: select 1 res
1171: from sys.dual
1172: where exists (
1173: select null
1174: from pay_action_classifications acl,
1175: pay_assignment_actions ac2,
1176: pay_payroll_actions pa2
1177: where ac2.assignment_id = p_asg_id
1178: and pa2.payroll_action_id = ac2.payroll_action_id
2909: and pay_pac.effective_date between
2910: pay_asg.effective_start_date and pay_asg.effective_end_date
2911: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
2912: and exists (select null
2913: from pay_action_classifications pay_pcl,
2914: pay_assignment_actions pay_act,
2915: per_all_assignments_f pay_asg2,
2916: pay_payroll_actions pay_pac2
2917: where pay_pac2.consolidation_set_id +0 = pay_pac.consolidation_set_id
3198: and pay_inc.include_or_exclude = ''I''
3199: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3200: and pay_as2.rowid = pay_asg.rowid
3201: and exists (select null
3202: from pay_action_classifications pay_pcl,
3203: pay_assignment_actions pay_act,
3204: per_all_assignments_f pay_asg2,
3205: pay_payroll_actions pay_pac2
3206: where pay_pac2.consolidation_set_id +0 = pay_pac.consolidation_set_id
3385: -- this one is for time independent legislation.
3386: intind := '
3387: and not exists (
3388: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3389: from pay_action_classifications pay_acl,
3390: pay_payroll_actions pay_pa2,
3391: pay_assignment_actions pay_ac2
3392: where pay_ac2.assignment_id = pay_asg.assignment_id
3393: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3399: --
3400: intbal := '
3401: and not exists (
3402: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3403: from pay_action_classifications pay_acl,
3404: pay_payroll_actions pay_pa2,
3405: pay_assignment_actions pay_ac2
3406: where pay_ac2.assignment_id = pay_asg.assignment_id
3407: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3520: intretind := '
3521: and not exists (
3522: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */
3523: null
3524: from pay_action_classifications pay_acl,
3525: pay_payroll_actions pay_pa2,
3526: pay_assignment_actions pay_ac2
3527: where pay_ac2.assignment_id = pay_asg.assignment_id
3528: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id