[Home] [Help]
1020: where not exists
1021: (select null
1022: from pay_assignment_actions ACT,
1023: pay_payroll_actions PACT,
1024: pay_action_classifications CLASS,
1025: pay_action_classifications CLAS2
1026: where ACT.assignment_id = p_assact_rec.assignment_id
1027: and ACT.action_sequence > l_action_sequence
1028: and ACT.action_status <> 'M'
1021: (select null
1022: from pay_assignment_actions ACT,
1023: pay_payroll_actions PACT,
1024: pay_action_classifications CLASS,
1025: pay_action_classifications CLAS2
1026: where ACT.assignment_id = p_assact_rec.assignment_id
1027: and ACT.action_sequence > l_action_sequence
1028: and ACT.action_status <> 'M'
1029: and ACT.payroll_action_id = PACT.payroll_action_id
1041: where not exists
1042: (select null
1043: from pay_assignment_actions ACT,
1044: pay_payroll_actions PACT,
1045: pay_action_classifications CLASS,
1046: pay_action_classifications CLAS2
1047: where ACT.assignment_id = p_assact_rec.assignment_id
1048: and ACT.action_sequence > l_action_sequence
1049: and ACT.payroll_action_id = PACT.payroll_action_id
1042: (select null
1043: from pay_assignment_actions ACT,
1044: pay_payroll_actions PACT,
1045: pay_action_classifications CLASS,
1046: pay_action_classifications CLAS2
1047: where ACT.assignment_id = p_assact_rec.assignment_id
1048: and ACT.action_sequence > l_action_sequence
1049: and ACT.payroll_action_id = PACT.payroll_action_id
1050: and PACT.action_type = CLASS.action_type
1064: select null into dummy
1065: from dual
1066: where not exists
1067: (select null
1068: from pay_action_classifications CLASS,
1069: pay_action_classifications CLAS2,
1070: pay_payroll_actions PACT,
1071: pay_assignment_actions ACT,
1072: per_all_assignments_f ASS,
1065: from dual
1066: where not exists
1067: (select null
1068: from pay_action_classifications CLASS,
1069: pay_action_classifications CLAS2,
1070: pay_payroll_actions PACT,
1071: pay_assignment_actions ACT,
1072: per_all_assignments_f ASS,
1073: per_periods_of_service POS
1086: select null into dummy
1087: from dual
1088: where not exists
1089: (select null
1090: from pay_action_classifications CLASS,
1091: pay_action_classifications CLAS2,
1092: pay_payroll_actions PACT,
1093: pay_assignment_actions ACT,
1094: per_all_assignments_f ASS,
1087: from dual
1088: where not exists
1089: (select null
1090: from pay_action_classifications CLASS,
1091: pay_action_classifications CLAS2,
1092: pay_payroll_actions PACT,
1093: pay_assignment_actions ACT,
1094: per_all_assignments_f ASS,
1095: per_periods_of_service POS
1183: into dummy
1184: from dual
1185: where not exists
1186: (select null
1187: from pay_action_classifications
1188: where action_type = p_pact_rec.action_type
1189: and classification_name = 'NONREMOVEABLE');
1190: exception
1191: when no_data_found then
1218: hr_utility.set_location('hrassact.val_pact_rollback', 40);
1219: end if;
1220: select null
1221: into dummy
1222: from pay_action_classifications CLASS
1223: where CLASS.action_type = p_pact_rec.action_type
1224: and CLASS.classification_name = 'SEQUENCED';
1225: if g_debug then
1226: hr_utility.trace('this action type IS sequenced');
3228: chldact varchar2
3229: ) is
3230: select ac2.rowid,
3231: ac2.assignment_action_id
3232: from pay_action_classifications acl,
3233: pay_assignment_actions ac2,
3234: pay_assignment_actions paa,
3235: pay_payroll_actions ppa,
3236: pay_payroll_actions pa2
3263: per_all_assignments_f asg,
3264: per_all_assignments_f as2,
3265: pay_assignment_actions ac2,
3266: pay_payroll_actions pa2,
3267: pay_action_classifications acl
3268: where act.assignment_action_id = aaid
3269: and pac.payroll_action_id = act.payroll_action_id
3270: and asg.assignment_id = act.assignment_id
3271: and pac.effective_date between
3308: pay_payroll_actions pac,
3309: pay_object_groups pog4,
3310: pay_assignment_actions ac3,
3311: pay_payroll_actions pa3,
3312: pay_action_classifications acl
3313: where act.assignment_action_id = aaid
3314: and pac.payroll_action_id = act.payroll_action_id
3315: and pog.source_id = act.assignment_id
3316: and pog.source_type = 'PAF'
3376: pay_payroll_actions pac,
3377: pay_object_groups pog3,
3378: pay_assignment_actions ac3,
3379: pay_payroll_actions pa3,
3380: pay_action_classifications acl
3381: where act.assignment_action_id = aaid
3382: and pac.payroll_action_id = act.payroll_action_id
3383: and pog.object_group_id = act.object_id
3384: and pog.source_type = 'PPF'
3536: ac2.rowid,
3537: ac2.assignment_action_id,
3538: ac2.source_action_id,
3539: ac2.object_type
3540: from pay_action_classifications acl,
3541: pay_assignment_actions ac2,
3542: pay_payroll_actions pa2
3543: where ac2.assignment_id = asgid
3544: and pa2.payroll_action_id = ac2.payroll_action_id
3569: per_all_assignments_f as2,
3570: pay_assignment_actions act,
3571: pay_assignment_actions ac2,
3572: pay_payroll_actions pa2,
3573: pay_action_classifications acl
3574: where pac.payroll_action_id = pactid
3575: and act.payroll_action_id = pac.payroll_action_id
3576: and act.assignment_id = asgid
3577: and act.source_action_id is null
3622: pay_object_groups pog3,
3623: pay_object_groups pog4,
3624: pay_assignment_actions ac3,
3625: pay_payroll_actions pa3,
3626: pay_action_classifications acl
3627: where pac.payroll_action_id = pactid
3628: and act.payroll_action_id = pac.payroll_action_id
3629: and act.assignment_id = asgid
3630: and act.source_action_id is null
4149: cursor seqasg (pactid number,
4150: asgid number) is
4151: select ac2.rowid,
4152: ac2.assignment_action_id
4153: from pay_action_classifications acl,
4154: pay_assignment_actions ac2,
4155: pay_assignment_actions act,
4156: pay_payroll_actions pa2,
4157: pay_payroll_actions pac
4186: per_all_assignments_f asg,
4187: per_all_assignments_f as2,
4188: pay_assignment_actions ac2,
4189: pay_payroll_actions pa2,
4190: pay_action_classifications acl
4191: where pac.payroll_action_id = pactid
4192: and act.payroll_action_id = pac.payroll_action_id
4193: and act.assignment_id = asgid
4194: and asg.assignment_id = act.assignment_id
4233: pay_object_groups pog3,
4234: pay_object_groups pog4,
4235: pay_assignment_actions ac3,
4236: pay_payroll_actions pa3,
4237: pay_action_classifications acl
4238: where pac.payroll_action_id = pactid
4239: and act.payroll_action_id = pac.payroll_action_id
4240: and act.assignment_id = asgid
4241: and pog.source_id = act.assignment_id
4418: into aa_exists
4419: from dual
4420: where exists (
4421: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4422: from pay_action_classifications pay_acl,
4423: pay_payroll_actions pay_pa2,
4424: pay_assignment_actions pay_ac2
4425: where pay_ac2.assignment_id = asgid
4426: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
4439: into aa_exists
4440: from sys.dual
4441: where exists (
4442: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4443: from pay_action_classifications pay_acl,
4444: pay_payroll_actions pay_pa2,
4445: pay_assignment_actions pay_ac2
4446: where pay_ac2.assignment_id = dprec.assignment_id
4447: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
4464: into aa_exists
4465: from sys.dual
4466: where exists (
4467: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4468: from pay_action_classifications pay_acl,
4469: pay_payroll_actions pay_pa2,
4470: pay_assignment_actions pay_ac2
4471: where pay_ac2.assignment_id = dprec.assignment_id
4472: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
4770: as2.effective_start_date and as2.effective_end_date
4771: and pbg.business_group_id = pac.business_group_id
4772: and not exists (
4773: select null
4774: from pay_action_classifications acl,
4775: pay_payroll_actions pa2,
4776: pay_assignment_actions ac2
4777: where ac2.assignment_id = asg.assignment_id
4778: and pa2.payroll_action_id = ac2.payroll_action_id
4878: and pbg.business_group_id = pac.business_group_id
4879: and not exists (
4880: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4881: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4882: from pay_action_classifications acl,
4883: pay_assignment_actions ac2,
4884: pay_payroll_actions pa2,
4885: pay_object_groups pog2
4886: where pog2.parent_object_group_id = pog.parent_object_group_id
4985: and pbg.business_group_id = pac.business_group_id
4986: and not exists (
4987: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4988: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4989: from pay_action_classifications acl,
4990: pay_assignment_actions ac2,
4991: pay_payroll_actions pa2,
4992: per_all_assignments_f as2
4993: where as2.period_of_service_id = pos.period_of_service_id
5417: ac2.tax_unit_id,
5418: ac2.run_type_id,
5419: pbg.legislation_code
5420: into asgid, taxunt,run_type_id, leg_code
5421: from pay_action_classifications acl,
5422: pay_assignment_actions ac2,
5423: pay_payroll_actions pa2,
5424: per_business_groups_perf pbg,
5425: pay_payroll_actions pac