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_OBJECT_GROUPS

Line 3305: pay_object_groups pog,

3301: from
3302: (
3303: select distinct ac3.assignment_action_id
3304: from pay_assignment_actions act,
3305: pay_object_groups pog,
3306: pay_object_groups pog2,
3307: pay_object_groups pog3,
3308: pay_payroll_actions pac,
3309: pay_object_groups pog4,

Line 3306: pay_object_groups pog2,

3302: (
3303: select distinct ac3.assignment_action_id
3304: from pay_assignment_actions act,
3305: pay_object_groups pog,
3306: pay_object_groups pog2,
3307: pay_object_groups pog3,
3308: pay_payroll_actions pac,
3309: pay_object_groups pog4,
3310: pay_assignment_actions ac3,

Line 3307: pay_object_groups pog3,

3303: select distinct ac3.assignment_action_id
3304: from pay_assignment_actions act,
3305: pay_object_groups pog,
3306: pay_object_groups pog2,
3307: pay_object_groups pog3,
3308: pay_payroll_actions pac,
3309: pay_object_groups pog4,
3310: pay_assignment_actions ac3,
3311: pay_payroll_actions pa3,

Line 3309: pay_object_groups pog4,

3305: pay_object_groups pog,
3306: pay_object_groups pog2,
3307: pay_object_groups pog3,
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

Line 3331: pay_object_groups pog,

3327: and acl.classification_name = 'SEQUENCED'
3328: union all
3329: select distinct ac3.assignment_action_id
3330: from pay_assignment_actions act,
3331: pay_object_groups pog,
3332: pay_object_groups pog2,
3333: pay_object_groups pog3,
3334: pay_payroll_actions pac,
3335: pay_assignment_actions ac3,

Line 3332: pay_object_groups pog2,

3328: union all
3329: select distinct ac3.assignment_action_id
3330: from pay_assignment_actions act,
3331: pay_object_groups pog,
3332: pay_object_groups pog2,
3333: pay_object_groups pog3,
3334: pay_payroll_actions pac,
3335: pay_assignment_actions ac3,
3336: pay_payroll_actions pa3

Line 3333: pay_object_groups pog3,

3329: select distinct ac3.assignment_action_id
3330: from pay_assignment_actions act,
3331: pay_object_groups pog,
3332: pay_object_groups pog2,
3333: pay_object_groups pog3,
3334: pay_payroll_actions pac,
3335: pay_assignment_actions ac3,
3336: pay_payroll_actions pa3
3337: where act.assignment_action_id = aaid

Line 3374: pay_object_groups pog,

3370: from
3371: (
3372: select distinct ac3.assignment_action_id
3373: from pay_assignment_actions act,
3374: pay_object_groups pog,
3375: pay_object_groups pog2,
3376: pay_payroll_actions pac,
3377: pay_object_groups pog3,
3378: pay_assignment_actions ac3,

Line 3375: pay_object_groups pog2,

3371: (
3372: select distinct ac3.assignment_action_id
3373: from pay_assignment_actions act,
3374: pay_object_groups pog,
3375: pay_object_groups pog2,
3376: pay_payroll_actions pac,
3377: pay_object_groups pog3,
3378: pay_assignment_actions ac3,
3379: pay_payroll_actions pa3,

Line 3377: pay_object_groups pog3,

3373: from pay_assignment_actions act,
3374: pay_object_groups pog,
3375: pay_object_groups pog2,
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

Line 3397: pay_object_groups pog,

3393: and acl.classification_name = 'SEQUENCED'
3394: union all
3395: select distinct ac3.assignment_action_id
3396: from pay_assignment_actions act,
3397: pay_object_groups pog,
3398: pay_object_groups pog2,
3399: pay_payroll_actions pac,
3400: pay_assignment_actions ac3,
3401: pay_payroll_actions pa3

Line 3398: pay_object_groups pog2,

3394: union all
3395: select distinct ac3.assignment_action_id
3396: from pay_assignment_actions act,
3397: pay_object_groups pog,
3398: pay_object_groups pog2,
3399: pay_payroll_actions pac,
3400: pay_assignment_actions ac3,
3401: pay_payroll_actions pa3
3402: where act.assignment_action_id = aaid

Line 3620: pay_object_groups pog,

3616: select /*+ ORDERED */
3617: distinct ac3.assignment_action_id
3618: from pay_payroll_actions pac,
3619: pay_assignment_actions act,
3620: pay_object_groups pog,
3621: pay_object_groups pog2,
3622: pay_object_groups pog3,
3623: pay_object_groups pog4,
3624: pay_assignment_actions ac3,

Line 3621: pay_object_groups pog2,

3617: distinct ac3.assignment_action_id
3618: from pay_payroll_actions pac,
3619: pay_assignment_actions act,
3620: pay_object_groups pog,
3621: pay_object_groups pog2,
3622: pay_object_groups pog3,
3623: pay_object_groups pog4,
3624: pay_assignment_actions ac3,
3625: pay_payroll_actions pa3,

Line 3622: pay_object_groups pog3,

3618: from pay_payroll_actions pac,
3619: pay_assignment_actions act,
3620: pay_object_groups pog,
3621: pay_object_groups pog2,
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

Line 3623: pay_object_groups pog4,

3619: pay_assignment_actions act,
3620: pay_object_groups pog,
3621: pay_object_groups pog2,
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

Line 3651: pay_object_groups pog,

3647: select /*+ ORDERED */
3648: distinct ac3.assignment_action_id
3649: from pay_payroll_actions pac,
3650: pay_assignment_actions act,
3651: pay_object_groups pog,
3652: pay_object_groups pog2,
3653: pay_object_groups pog3,
3654: pay_assignment_actions ac3,
3655: pay_payroll_actions pa3

Line 3652: pay_object_groups pog2,

3648: distinct ac3.assignment_action_id
3649: from pay_payroll_actions pac,
3650: pay_assignment_actions act,
3651: pay_object_groups pog,
3652: pay_object_groups pog2,
3653: pay_object_groups pog3,
3654: pay_assignment_actions ac3,
3655: pay_payroll_actions pa3
3656: where pac.payroll_action_id = pactid

Line 3653: pay_object_groups pog3,

3649: from pay_payroll_actions pac,
3650: pay_assignment_actions act,
3651: pay_object_groups pog,
3652: pay_object_groups pog2,
3653: pay_object_groups pog3,
3654: pay_assignment_actions ac3,
3655: pay_payroll_actions pa3
3656: where pac.payroll_action_id = pactid
3657: and act.payroll_action_id = pac.payroll_action_id

Line 4231: pay_object_groups pog,

4227: select /*+ ORDERED */
4228: distinct ac3.assignment_action_id
4229: from pay_payroll_actions pac,
4230: pay_assignment_actions act,
4231: pay_object_groups pog,
4232: pay_object_groups pog2,
4233: pay_object_groups pog3,
4234: pay_object_groups pog4,
4235: pay_assignment_actions ac3,

Line 4232: pay_object_groups pog2,

4228: distinct ac3.assignment_action_id
4229: from pay_payroll_actions pac,
4230: pay_assignment_actions act,
4231: pay_object_groups pog,
4232: pay_object_groups pog2,
4233: pay_object_groups pog3,
4234: pay_object_groups pog4,
4235: pay_assignment_actions ac3,
4236: pay_payroll_actions pa3,

Line 4233: pay_object_groups pog3,

4229: from pay_payroll_actions pac,
4230: pay_assignment_actions act,
4231: pay_object_groups pog,
4232: pay_object_groups pog2,
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

Line 4234: pay_object_groups pog4,

4230: pay_assignment_actions act,
4231: pay_object_groups pog,
4232: pay_object_groups pog2,
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

Line 4259: pay_object_groups pog,

4255: select /*+ ORDERED */
4256: distinct ac3.assignment_action_id
4257: from pay_payroll_actions pac,
4258: pay_assignment_actions act,
4259: pay_object_groups pog,
4260: pay_object_groups pog2,
4261: pay_object_groups pog3,
4262: pay_assignment_actions ac3,
4263: pay_payroll_actions pa3

Line 4260: pay_object_groups pog2,

4256: distinct ac3.assignment_action_id
4257: from pay_payroll_actions pac,
4258: pay_assignment_actions act,
4259: pay_object_groups pog,
4260: pay_object_groups pog2,
4261: pay_object_groups pog3,
4262: pay_assignment_actions ac3,
4263: pay_payroll_actions pa3
4264: where pac.payroll_action_id = pactid

Line 4261: pay_object_groups pog3,

4257: from pay_payroll_actions pac,
4258: pay_assignment_actions act,
4259: pay_object_groups pog,
4260: pay_object_groups pog2,
4261: pay_object_groups pog3,
4262: pay_assignment_actions ac3,
4263: pay_payroll_actions pa3
4264: where pac.payroll_action_id = pactid
4265: and act.payroll_action_id = pac.payroll_action_id

Line 4292: from pay_object_groups pog_act,

4288: where paf.person_id = persid;
4289: --
4290: cursor perobj (asgid number) is
4291: select distinct pog_grp.source_id assignment_id
4292: from pay_object_groups pog_act,
4293: pay_object_groups pog_grp
4294: where pog_act.source_id = asgid
4295: and pog_act.source_type = 'PAF'
4296: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id

Line 4293: pay_object_groups pog_grp

4289: --
4290: cursor perobj (asgid number) is
4291: select distinct pog_grp.source_id assignment_id
4292: from pay_object_groups pog_act,
4293: pay_object_groups pog_grp
4294: where pog_act.source_id = asgid
4295: and pog_act.source_type = 'PAF'
4296: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id
4297: and pog_grp.source_type = 'PAF';

Line 4813: pay_object_groups pog,

4809: pac.effective_date)
4810: from per_business_groups_perf pbg,
4811: per_all_assignments_f asg,
4812: per_all_assignments_f as2,
4813: pay_object_groups pog,
4814: pay_payroll_actions pac
4815: where pac.payroll_action_id = pactid
4816: and asg.payroll_id = pac.payroll_id
4817: and asg.assignment_id = asgid

Line 4833: pay_object_groups pog2,

4829: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4830: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4831: from pay_assignment_actions ac2,
4832: pay_payroll_actions pa2,
4833: pay_object_groups pog2,
4834: per_time_periods ptp
4835: where pog2.parent_object_group_id = pog.parent_object_group_id
4836: and ac2.assignment_id = pog2.source_id
4837: and pa2.payroll_action_id = ac2.payroll_action_id

Line 4864: pay_object_groups pog,

4860: pac.effective_date)
4861: from per_business_groups_perf pbg,
4862: per_all_assignments_f asg,
4863: per_all_assignments_f as2,
4864: pay_object_groups pog,
4865: pay_payroll_actions pac
4866: where pac.payroll_action_id = pactid
4867: and asg.payroll_id = pac.payroll_id
4868: and asg.assignment_id = asgid

Line 4885: pay_object_groups pog2

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
4887: and ac2.assignment_id = pog2.source_id
4888: and pa2.payroll_action_id = ac2.payroll_action_id
4889: and acl.classification_name = 'SEQUENCED'

Line 7071: from pay_object_groups pog

7067: and plb.person_id = p_person_id
7068: and ( plb.assignment_id = p_asg_id
7069: or plb.assignment_id is null)
7070: and ( plb.process_group_id = (select distinct parent_object_group_id
7071: from pay_object_groups pog
7072: where pog.source_id = p_asg_id
7073: and pog.source_type = 'PAF')
7074: or plb.process_group_id is null);
7075: