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 3285: pay_object_groups pog,

3281: from
3282: (
3283: select distinct ac3.assignment_action_id
3284: from pay_assignment_actions act,
3285: pay_object_groups pog,
3286: pay_object_groups pog2,
3287: pay_object_groups pog3,
3288: pay_payroll_actions pac,
3289: pay_object_groups pog4,

Line 3286: pay_object_groups pog2,

3282: (
3283: select distinct ac3.assignment_action_id
3284: from pay_assignment_actions act,
3285: pay_object_groups pog,
3286: pay_object_groups pog2,
3287: pay_object_groups pog3,
3288: pay_payroll_actions pac,
3289: pay_object_groups pog4,
3290: pay_assignment_actions ac3,

Line 3287: pay_object_groups pog3,

3283: select distinct ac3.assignment_action_id
3284: from pay_assignment_actions act,
3285: pay_object_groups pog,
3286: pay_object_groups pog2,
3287: pay_object_groups pog3,
3288: pay_payroll_actions pac,
3289: pay_object_groups pog4,
3290: pay_assignment_actions ac3,
3291: pay_payroll_actions pa3,

Line 3289: pay_object_groups pog4,

3285: pay_object_groups pog,
3286: pay_object_groups pog2,
3287: pay_object_groups pog3,
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

Line 3311: pay_object_groups pog,

3307: and acl.classification_name = 'SEQUENCED'
3308: union all
3309: select distinct ac3.assignment_action_id
3310: from pay_assignment_actions act,
3311: pay_object_groups pog,
3312: pay_object_groups pog2,
3313: pay_object_groups pog3,
3314: pay_payroll_actions pac,
3315: pay_assignment_actions ac3,

Line 3312: pay_object_groups pog2,

3308: union all
3309: select distinct ac3.assignment_action_id
3310: from pay_assignment_actions act,
3311: pay_object_groups pog,
3312: pay_object_groups pog2,
3313: pay_object_groups pog3,
3314: pay_payroll_actions pac,
3315: pay_assignment_actions ac3,
3316: pay_payroll_actions pa3

Line 3313: pay_object_groups pog3,

3309: select distinct ac3.assignment_action_id
3310: from pay_assignment_actions act,
3311: pay_object_groups pog,
3312: pay_object_groups pog2,
3313: pay_object_groups pog3,
3314: pay_payroll_actions pac,
3315: pay_assignment_actions ac3,
3316: pay_payroll_actions pa3
3317: where act.assignment_action_id = aaid

Line 3354: pay_object_groups pog,

3350: from
3351: (
3352: select distinct ac3.assignment_action_id
3353: from pay_assignment_actions act,
3354: pay_object_groups pog,
3355: pay_object_groups pog2,
3356: pay_payroll_actions pac,
3357: pay_object_groups pog3,
3358: pay_assignment_actions ac3,

Line 3355: pay_object_groups pog2,

3351: (
3352: select distinct ac3.assignment_action_id
3353: from pay_assignment_actions act,
3354: pay_object_groups pog,
3355: pay_object_groups pog2,
3356: pay_payroll_actions pac,
3357: pay_object_groups pog3,
3358: pay_assignment_actions ac3,
3359: pay_payroll_actions pa3,

Line 3357: pay_object_groups pog3,

3353: from pay_assignment_actions act,
3354: pay_object_groups pog,
3355: pay_object_groups pog2,
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

Line 3377: pay_object_groups pog,

3373: and acl.classification_name = 'SEQUENCED'
3374: union all
3375: select distinct ac3.assignment_action_id
3376: from pay_assignment_actions act,
3377: pay_object_groups pog,
3378: pay_object_groups pog2,
3379: pay_payroll_actions pac,
3380: pay_assignment_actions ac3,
3381: pay_payroll_actions pa3

Line 3378: pay_object_groups pog2,

3374: union all
3375: select distinct ac3.assignment_action_id
3376: from pay_assignment_actions act,
3377: pay_object_groups pog,
3378: pay_object_groups pog2,
3379: pay_payroll_actions pac,
3380: pay_assignment_actions ac3,
3381: pay_payroll_actions pa3
3382: where act.assignment_action_id = aaid

Line 3600: pay_object_groups pog,

3596: select /*+ ORDERED */
3597: distinct ac3.assignment_action_id
3598: from pay_payroll_actions pac,
3599: pay_assignment_actions act,
3600: pay_object_groups pog,
3601: pay_object_groups pog2,
3602: pay_object_groups pog3,
3603: pay_object_groups pog4,
3604: pay_assignment_actions ac3,

Line 3601: pay_object_groups pog2,

3597: distinct ac3.assignment_action_id
3598: from pay_payroll_actions pac,
3599: pay_assignment_actions act,
3600: pay_object_groups pog,
3601: pay_object_groups pog2,
3602: pay_object_groups pog3,
3603: pay_object_groups pog4,
3604: pay_assignment_actions ac3,
3605: pay_payroll_actions pa3,

Line 3602: pay_object_groups pog3,

3598: from pay_payroll_actions pac,
3599: pay_assignment_actions act,
3600: pay_object_groups pog,
3601: pay_object_groups pog2,
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

Line 3603: pay_object_groups pog4,

3599: pay_assignment_actions act,
3600: pay_object_groups pog,
3601: pay_object_groups pog2,
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

Line 3631: pay_object_groups pog,

3627: select /*+ ORDERED */
3628: distinct ac3.assignment_action_id
3629: from pay_payroll_actions pac,
3630: pay_assignment_actions act,
3631: pay_object_groups pog,
3632: pay_object_groups pog2,
3633: pay_object_groups pog3,
3634: pay_assignment_actions ac3,
3635: pay_payroll_actions pa3

Line 3632: pay_object_groups pog2,

3628: distinct ac3.assignment_action_id
3629: from pay_payroll_actions pac,
3630: pay_assignment_actions act,
3631: pay_object_groups pog,
3632: pay_object_groups pog2,
3633: pay_object_groups pog3,
3634: pay_assignment_actions ac3,
3635: pay_payroll_actions pa3
3636: where pac.payroll_action_id = pactid

Line 3633: pay_object_groups pog3,

3629: from pay_payroll_actions pac,
3630: pay_assignment_actions act,
3631: pay_object_groups pog,
3632: pay_object_groups pog2,
3633: pay_object_groups pog3,
3634: pay_assignment_actions ac3,
3635: pay_payroll_actions pa3
3636: where pac.payroll_action_id = pactid
3637: and act.payroll_action_id = pac.payroll_action_id

Line 4211: pay_object_groups pog,

4207: select /*+ ORDERED */
4208: distinct ac3.assignment_action_id
4209: from pay_payroll_actions pac,
4210: pay_assignment_actions act,
4211: pay_object_groups pog,
4212: pay_object_groups pog2,
4213: pay_object_groups pog3,
4214: pay_object_groups pog4,
4215: pay_assignment_actions ac3,

Line 4212: pay_object_groups pog2,

4208: distinct ac3.assignment_action_id
4209: from pay_payroll_actions pac,
4210: pay_assignment_actions act,
4211: pay_object_groups pog,
4212: pay_object_groups pog2,
4213: pay_object_groups pog3,
4214: pay_object_groups pog4,
4215: pay_assignment_actions ac3,
4216: pay_payroll_actions pa3,

Line 4213: pay_object_groups pog3,

4209: from pay_payroll_actions pac,
4210: pay_assignment_actions act,
4211: pay_object_groups pog,
4212: pay_object_groups pog2,
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

Line 4214: pay_object_groups pog4,

4210: pay_assignment_actions act,
4211: pay_object_groups pog,
4212: pay_object_groups pog2,
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

Line 4239: pay_object_groups pog,

4235: select /*+ ORDERED */
4236: distinct ac3.assignment_action_id
4237: from pay_payroll_actions pac,
4238: pay_assignment_actions act,
4239: pay_object_groups pog,
4240: pay_object_groups pog2,
4241: pay_object_groups pog3,
4242: pay_assignment_actions ac3,
4243: pay_payroll_actions pa3

Line 4240: pay_object_groups pog2,

4236: distinct ac3.assignment_action_id
4237: from pay_payroll_actions pac,
4238: pay_assignment_actions act,
4239: pay_object_groups pog,
4240: pay_object_groups pog2,
4241: pay_object_groups pog3,
4242: pay_assignment_actions ac3,
4243: pay_payroll_actions pa3
4244: where pac.payroll_action_id = pactid

Line 4241: pay_object_groups pog3,

4237: from pay_payroll_actions pac,
4238: pay_assignment_actions act,
4239: pay_object_groups pog,
4240: pay_object_groups pog2,
4241: pay_object_groups pog3,
4242: pay_assignment_actions ac3,
4243: pay_payroll_actions pa3
4244: where pac.payroll_action_id = pactid
4245: and act.payroll_action_id = pac.payroll_action_id

Line 4272: from pay_object_groups pog_act,

4268: where paf.person_id = persid;
4269: --
4270: cursor perobj (asgid number) is
4271: select distinct pog_grp.source_id assignment_id
4272: from pay_object_groups pog_act,
4273: pay_object_groups pog_grp
4274: where pog_act.source_id = asgid
4275: and pog_act.source_type = 'PAF'
4276: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id

Line 4273: pay_object_groups pog_grp

4269: --
4270: cursor perobj (asgid number) is
4271: select distinct pog_grp.source_id assignment_id
4272: from pay_object_groups pog_act,
4273: pay_object_groups pog_grp
4274: where pog_act.source_id = asgid
4275: and pog_act.source_type = 'PAF'
4276: and pog_act.parent_object_group_id = pog_grp.parent_object_group_id
4277: and pog_grp.source_type = 'PAF';

Line 6807: from pay_object_groups pog

6803: and plb.person_id = p_person_id
6804: and ( plb.assignment_id = p_asg_id
6805: or plb.assignment_id is null)
6806: and ( plb.process_group_id = (select distinct parent_object_group_id
6807: from pay_object_groups pog
6808: where pog.source_id = p_asg_id
6809: and pog.source_type = 'PAF')
6810: or plb.process_group_id is null);
6811: