eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRASSACT dependencies on PAY_ACTION_CLASSIFICATIONS

Line 992: pay_action_classifications CLASS,

988: where not exists
989: (select null
990: from pay_assignment_actions ACT,
991: pay_payroll_actions PACT,
992: pay_action_classifications CLASS,
993: pay_action_classifications CLAS2
994: where ACT.assignment_id = p_assact_rec.assignment_id
995: and ACT.action_sequence > l_action_sequence
996: and ACT.action_status <> 'M'

Line 993: pay_action_classifications CLAS2

989: (select null
990: from pay_assignment_actions ACT,
991: pay_payroll_actions PACT,
992: pay_action_classifications CLASS,
993: pay_action_classifications CLAS2
994: where ACT.assignment_id = p_assact_rec.assignment_id
995: and ACT.action_sequence > l_action_sequence
996: and ACT.action_status <> 'M'
997: and ACT.payroll_action_id = PACT.payroll_action_id

Line 1013: pay_action_classifications CLASS,

1009: where not exists
1010: (select null
1011: from pay_assignment_actions ACT,
1012: pay_payroll_actions PACT,
1013: pay_action_classifications CLASS,
1014: pay_action_classifications CLAS2
1015: where ACT.assignment_id = p_assact_rec.assignment_id
1016: and ACT.action_sequence > l_action_sequence
1017: and ACT.payroll_action_id = PACT.payroll_action_id

Line 1014: pay_action_classifications CLAS2

1010: (select null
1011: from pay_assignment_actions ACT,
1012: pay_payroll_actions PACT,
1013: pay_action_classifications CLASS,
1014: pay_action_classifications CLAS2
1015: where ACT.assignment_id = p_assact_rec.assignment_id
1016: and ACT.action_sequence > l_action_sequence
1017: and ACT.payroll_action_id = PACT.payroll_action_id
1018: and PACT.action_type = CLASS.action_type

Line 1036: from pay_action_classifications CLASS,

1032: select null into dummy
1033: from dual
1034: where not exists
1035: (select null
1036: from pay_action_classifications CLASS,
1037: pay_action_classifications CLAS2,
1038: pay_payroll_actions PACT,
1039: pay_assignment_actions ACT,
1040: per_all_assignments_f ASS,

Line 1037: pay_action_classifications CLAS2,

1033: from dual
1034: where not exists
1035: (select null
1036: from pay_action_classifications CLASS,
1037: pay_action_classifications CLAS2,
1038: pay_payroll_actions PACT,
1039: pay_assignment_actions ACT,
1040: per_all_assignments_f ASS,
1041: per_periods_of_service POS

Line 1058: from pay_action_classifications CLASS,

1054: select null into dummy
1055: from dual
1056: where not exists
1057: (select null
1058: from pay_action_classifications CLASS,
1059: pay_action_classifications CLAS2,
1060: pay_payroll_actions PACT,
1061: pay_assignment_actions ACT,
1062: per_all_assignments_f ASS,

Line 1059: pay_action_classifications CLAS2,

1055: from dual
1056: where not exists
1057: (select null
1058: from pay_action_classifications CLASS,
1059: pay_action_classifications CLAS2,
1060: pay_payroll_actions PACT,
1061: pay_assignment_actions ACT,
1062: per_all_assignments_f ASS,
1063: per_periods_of_service POS

Line 1155: from pay_action_classifications

1151: into dummy
1152: from dual
1153: where not exists
1154: (select null
1155: from pay_action_classifications
1156: where action_type = p_pact_rec.action_type
1157: and classification_name = 'NONREMOVEABLE');
1158: exception
1159: when no_data_found then

Line 1190: from pay_action_classifications CLASS

1186: hr_utility.set_location('hrassact.val_pact_rollback', 40);
1187: end if;
1188: select null
1189: into dummy
1190: from pay_action_classifications CLASS
1191: where CLASS.action_type = p_pact_rec.action_type
1192: and CLASS.classification_name = 'SEQUENCED';
1193: if g_debug then
1194: hr_utility.trace('this action type IS sequenced');

Line 3215: from pay_action_classifications acl,

3211: chldact varchar2
3212: ) is
3213: select ac2.rowid,
3214: ac2.assignment_action_id
3215: from pay_action_classifications acl,
3216: pay_assignment_actions ac2,
3217: pay_assignment_actions paa,
3218: pay_payroll_actions ppa,
3219: pay_payroll_actions pa2

Line 3241: from pay_action_classifications acl,

3237: chldact varchar2
3238: ) is
3239: select ac2.rowid,
3240: ac2.assignment_action_id
3241: from pay_action_classifications acl,
3242: pay_assignment_actions ac2,
3243: pay_assignment_actions act,
3244: per_all_assignments_f as2,
3245: per_all_assignments_f asg,

Line 3292: pay_action_classifications acl

3288: pay_payroll_actions pac,
3289: pay_object_groups pog4,
3290: pay_assignment_actions ac3,
3291: pay_payroll_actions pa3,
3292: pay_action_classifications acl
3293: where act.assignment_action_id = aaid
3294: and pac.payroll_action_id = act.payroll_action_id
3295: and pog.source_id = act.assignment_id
3296: and pog.source_type = 'PAF'

Line 3360: pay_action_classifications acl

3356: pay_payroll_actions pac,
3357: pay_object_groups pog3,
3358: pay_assignment_actions ac3,
3359: pay_payroll_actions pa3,
3360: pay_action_classifications acl
3361: where act.assignment_action_id = aaid
3362: and pac.payroll_action_id = act.payroll_action_id
3363: and pog.object_group_id = act.object_id
3364: and pog.source_type = 'PPF'

Line 3520: from pay_action_classifications acl,

3516: ac2.rowid,
3517: ac2.assignment_action_id,
3518: ac2.source_action_id,
3519: ac2.object_type
3520: from pay_action_classifications acl,
3521: pay_assignment_actions ac2,
3522: pay_payroll_actions pa2
3523: where ac2.assignment_id = asgid
3524: and pa2.payroll_action_id = ac2.payroll_action_id

Line 3553: pay_action_classifications acl

3549: per_all_assignments_f as2,
3550: pay_assignment_actions act,
3551: pay_assignment_actions ac2,
3552: pay_payroll_actions pa2,
3553: pay_action_classifications acl
3554: where pac.payroll_action_id = pactid
3555: and act.payroll_action_id = pac.payroll_action_id
3556: and act.assignment_id = asgid
3557: and act.source_action_id is null

Line 3606: pay_action_classifications acl

3602: pay_object_groups pog3,
3603: pay_object_groups pog4,
3604: pay_assignment_actions ac3,
3605: pay_payroll_actions pa3,
3606: pay_action_classifications acl
3607: where pac.payroll_action_id = pactid
3608: and act.payroll_action_id = pac.payroll_action_id
3609: and act.assignment_id = asgid
3610: and act.source_action_id is null

Line 4133: from pay_action_classifications acl,

4129: cursor seqasg (pactid number,
4130: asgid number) is
4131: select ac2.rowid,
4132: ac2.assignment_action_id
4133: from pay_action_classifications acl,
4134: pay_assignment_actions ac2,
4135: pay_assignment_actions act,
4136: pay_payroll_actions pa2,
4137: pay_payroll_actions pac

Line 4170: pay_action_classifications acl

4166: per_all_assignments_f asg,
4167: per_all_assignments_f as2,
4168: pay_assignment_actions ac2,
4169: pay_payroll_actions pa2,
4170: pay_action_classifications acl
4171: where pac.payroll_action_id = pactid
4172: and act.payroll_action_id = pac.payroll_action_id
4173: and act.assignment_id = asgid
4174: and asg.assignment_id = act.assignment_id

Line 4217: pay_action_classifications acl

4213: pay_object_groups pog3,
4214: pay_object_groups pog4,
4215: pay_assignment_actions ac3,
4216: pay_payroll_actions pa3,
4217: pay_action_classifications acl
4218: where pac.payroll_action_id = pactid
4219: and act.payroll_action_id = pac.payroll_action_id
4220: and act.assignment_id = asgid
4221: and pog.source_id = act.assignment_id

Line 4402: from pay_action_classifications pay_acl,

4398: into aa_exists
4399: from dual
4400: where exists (
4401: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4402: from pay_action_classifications pay_acl,
4403: pay_payroll_actions pay_pa2,
4404: pay_assignment_actions pay_ac2
4405: where pay_ac2.assignment_id = asgid
4406: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id

Line 4423: from pay_action_classifications pay_acl,

4419: into aa_exists
4420: from sys.dual
4421: where exists (
4422: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4423: from pay_action_classifications pay_acl,
4424: pay_payroll_actions pay_pa2,
4425: pay_assignment_actions pay_ac2
4426: where pay_ac2.assignment_id = dprec.assignment_id
4427: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id

Line 4448: from pay_action_classifications pay_acl,

4444: into aa_exists
4445: from sys.dual
4446: where exists (
4447: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
4448: from pay_action_classifications pay_acl,
4449: pay_payroll_actions pay_pa2,
4450: pay_assignment_actions pay_ac2
4451: where pay_ac2.assignment_id = dprec.assignment_id
4452: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id

Line 4708: from pay_action_classifications acl,

4704: as2.effective_start_date and as2.effective_end_date
4705: and pbg.business_group_id = pac.business_group_id
4706: and not exists (
4707: select null
4708: from pay_action_classifications acl,
4709: pay_payroll_actions pa2,
4710: pay_assignment_actions ac2
4711: where ac2.assignment_id = asg.assignment_id
4712: and pa2.payroll_action_id = ac2.payroll_action_id

Line 4758: from pay_action_classifications acl,

4754: as2.effective_start_date and as2.effective_end_date
4755: and pbg.business_group_id = pac.business_group_id
4756: and not exists (
4757: select null
4758: from pay_action_classifications acl,
4759: pay_assignment_actions ac2,
4760: pay_payroll_actions pa2,
4761: per_all_assignments_f as2
4762: where as2.period_of_service_id = pos.period_of_service_id

Line 5189: from pay_action_classifications acl,

5185: ac2.tax_unit_id,
5186: ac2.run_type_id,
5187: pbg.legislation_code
5188: into asgid, taxunt,run_type_id, leg_code
5189: from pay_action_classifications acl,
5190: pay_assignment_actions ac2,
5191: pay_payroll_actions pa2,
5192: per_business_groups_perf pbg,
5193: pay_payroll_actions pac