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.PY_ROLLBACK_PKG dependencies on PAY_OBJECT_GROUPS

Line 690: from pay_object_groups pog

686: and lb.person_id = l_person_id
687: and ( lb.assignment_id = p_info.assignment_id
688: or lb.assignment_id is null)
689: and ( lb.process_group_id = (select distinct pog.parent_object_group_id
690: from pay_object_groups pog
691: where pog.source_id = p_info.assignment_id
692: and pog.source_type = 'PAF')
693: or lb.process_group_id is null)
694: and p_info.action_date between pbf.effective_start_date

Line 1988: pay_object_groups POG_PER,

1984: p_info.full_name,
1985: p_info.assignment_number
1986: from
1987: per_all_people_f PEO,
1988: pay_object_groups POG_PER,
1989: pay_assignment_actions ACT
1990: where ACT.assignment_action_id = p_info.assact_id
1991: and ACT.source_action_id is null
1992: and ACT.object_id = POG_PER.object_group_id

Line 2267: pay_object_groups POG_ASG,

2263: (select null
2264: from pay_action_classifications CLASS,
2265: pay_payroll_actions PACT,
2266: pay_assignment_actions ACT,
2267: pay_object_groups POG_ASG,
2268: pay_object_groups POG_PER,
2269: pay_assignment_actions PAA_RET
2270: where PAA_RET.assignment_action_id = p_info.assact_id
2271: and POG_PER.object_group_id = PAA_RET.object_id

Line 2268: pay_object_groups POG_PER,

2264: from pay_action_classifications CLASS,
2265: pay_payroll_actions PACT,
2266: pay_assignment_actions ACT,
2267: pay_object_groups POG_ASG,
2268: pay_object_groups POG_PER,
2269: pay_assignment_actions PAA_RET
2270: where PAA_RET.assignment_action_id = p_info.assact_id
2271: and POG_PER.object_group_id = PAA_RET.object_id
2272: and POG_PER.source_type = 'PPF'

Line 2289: pay_object_groups POG_ASG,

2285: (select null
2286: from pay_action_classifications CLASS,
2287: pay_payroll_actions PACT,
2288: pay_assignment_actions ACT,
2289: pay_object_groups POG_ASG,
2290: pay_object_groups POG_PER,
2291: pay_assignment_actions PAA_RET
2292: where PAA_RET.assignment_action_id = p_info.assact_id
2293: and POG_PER.object_group_id = PAA_RET.object_id

Line 2290: pay_object_groups POG_PER,

2286: from pay_action_classifications CLASS,
2287: pay_payroll_actions PACT,
2288: pay_assignment_actions ACT,
2289: pay_object_groups POG_ASG,
2290: pay_object_groups POG_PER,
2291: pay_assignment_actions PAA_RET
2292: where PAA_RET.assignment_action_id = p_info.assact_id
2293: and POG_PER.object_group_id = PAA_RET.object_id
2294: and POG_PER.source_type = 'PPF'

Line 2315: pay_object_groups POG_ASG,

2311: (select null
2312: from pay_action_classifications CLASS,
2313: pay_payroll_actions PACT,
2314: pay_assignment_actions ACT,
2315: pay_object_groups POG_ASG,
2316: pay_object_groups POG_ASG2
2317: where POG_ASG.source_type = 'PAF'
2318: and POG_ASG2.source_type = 'PAF'
2319: and POG_ASG.source_id = p_info.assignment_id

Line 2316: pay_object_groups POG_ASG2

2312: from pay_action_classifications CLASS,
2313: pay_payroll_actions PACT,
2314: pay_assignment_actions ACT,
2315: pay_object_groups POG_ASG,
2316: pay_object_groups POG_ASG2
2317: where POG_ASG.source_type = 'PAF'
2318: and POG_ASG2.source_type = 'PAF'
2319: and POG_ASG.source_id = p_info.assignment_id
2320: and POG_ASG.parent_object_group_id = POG_ASG2.parent_object_group_id

Line 2335: pay_object_groups POG_ASG,

2331: (select null
2332: from pay_action_classifications CLASS,
2333: pay_payroll_actions PACT,
2334: pay_assignment_actions ACT,
2335: pay_object_groups POG_ASG,
2336: pay_object_groups POG_ASG2
2337: where POG_ASG.source_type = 'PAF'
2338: and POG_ASG2.source_type = 'PAF'
2339: and POG_ASG.source_id = p_info.assignment_id

Line 2336: pay_object_groups POG_ASG2

2332: from pay_action_classifications CLASS,
2333: pay_payroll_actions PACT,
2334: pay_assignment_actions ACT,
2335: pay_object_groups POG_ASG,
2336: pay_object_groups POG_ASG2
2337: where POG_ASG.source_type = 'PAF'
2338: and POG_ASG2.source_type = 'PAF'
2339: and POG_ASG.source_id = p_info.assignment_id
2340: and POG_ASG.parent_object_group_id = POG_ASG2.parent_object_group_id