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 695: from pay_object_groups pog

691: and lb.person_id = l_person_id
692: and ( lb.assignment_id = p_info.assignment_id
693: or lb.assignment_id is null)
694: and ( lb.process_group_id = (select distinct pog.parent_object_group_id
695: from pay_object_groups pog
696: where pog.source_id = p_info.assignment_id
697: and pog.source_type = 'PAF')
698: or lb.process_group_id is null)
699: and p_info.action_date between pbf.effective_start_date

Line 2067: pay_object_groups POG_PER,

2063: p_info.full_name,
2064: p_info.assignment_number
2065: from
2066: per_all_people_f PEO,
2067: pay_object_groups POG_PER,
2068: pay_assignment_actions ACT
2069: where ACT.assignment_action_id = p_info.assact_id
2070: and ACT.source_action_id is null
2071: and ACT.object_id = POG_PER.object_group_id

Line 2351: pay_object_groups POG_ASG,

2347: (select null
2348: from pay_action_classifications CLASS,
2349: pay_payroll_actions PACT,
2350: pay_assignment_actions ACT,
2351: pay_object_groups POG_ASG,
2352: pay_object_groups POG_PER,
2353: pay_assignment_actions PAA_RET
2354: where PAA_RET.assignment_action_id = p_info.assact_id
2355: and POG_PER.object_group_id = PAA_RET.object_id

Line 2352: pay_object_groups POG_PER,

2348: from pay_action_classifications CLASS,
2349: pay_payroll_actions PACT,
2350: pay_assignment_actions ACT,
2351: pay_object_groups POG_ASG,
2352: pay_object_groups POG_PER,
2353: pay_assignment_actions PAA_RET
2354: where PAA_RET.assignment_action_id = p_info.assact_id
2355: and POG_PER.object_group_id = PAA_RET.object_id
2356: and POG_PER.source_type = 'PPF'

Line 2373: pay_object_groups POG_ASG,

2369: (select null
2370: from pay_action_classifications CLASS,
2371: pay_payroll_actions PACT,
2372: pay_assignment_actions ACT,
2373: pay_object_groups POG_ASG,
2374: pay_object_groups POG_PER,
2375: pay_assignment_actions PAA_RET
2376: where PAA_RET.assignment_action_id = p_info.assact_id
2377: and POG_PER.object_group_id = PAA_RET.object_id

Line 2374: pay_object_groups POG_PER,

2370: from pay_action_classifications CLASS,
2371: pay_payroll_actions PACT,
2372: pay_assignment_actions ACT,
2373: pay_object_groups POG_ASG,
2374: pay_object_groups POG_PER,
2375: pay_assignment_actions PAA_RET
2376: where PAA_RET.assignment_action_id = p_info.assact_id
2377: and POG_PER.object_group_id = PAA_RET.object_id
2378: and POG_PER.source_type = 'PPF'

Line 2400: pay_object_groups POG_ASG,

2396: (select null
2397: from pay_action_classifications CLASS,
2398: pay_payroll_actions PACT,
2399: pay_assignment_actions ACT,
2400: pay_object_groups POG_ASG,
2401: pay_object_groups POG_ASG2
2402: where POG_ASG.source_type = 'PAF'
2403: and POG_ASG2.source_type = 'PAF'
2404: and POG_ASG.source_id = p_info.assignment_id

Line 2401: pay_object_groups POG_ASG2

2397: from pay_action_classifications CLASS,
2398: pay_payroll_actions PACT,
2399: pay_assignment_actions ACT,
2400: pay_object_groups POG_ASG,
2401: pay_object_groups POG_ASG2
2402: where POG_ASG.source_type = 'PAF'
2403: and POG_ASG2.source_type = 'PAF'
2404: and POG_ASG.source_id = p_info.assignment_id
2405: and POG_ASG.parent_object_group_id = POG_ASG2.parent_object_group_id

Line 2420: pay_object_groups POG_ASG,

2416: (select null
2417: from pay_action_classifications CLASS,
2418: pay_payroll_actions PACT,
2419: pay_assignment_actions ACT,
2420: pay_object_groups POG_ASG,
2421: pay_object_groups POG_ASG2
2422: where POG_ASG.source_type = 'PAF'
2423: and POG_ASG2.source_type = 'PAF'
2424: and POG_ASG.source_id = p_info.assignment_id

Line 2421: pay_object_groups POG_ASG2

2417: from pay_action_classifications CLASS,
2418: pay_payroll_actions PACT,
2419: pay_assignment_actions ACT,
2420: pay_object_groups POG_ASG,
2421: pay_object_groups POG_ASG2
2422: where POG_ASG.source_type = 'PAF'
2423: and POG_ASG2.source_type = 'PAF'
2424: and POG_ASG.source_id = p_info.assignment_id
2425: and POG_ASG.parent_object_group_id = POG_ASG2.parent_object_group_id