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 PER_PERIODS_OF_SERVICE

Line 40: per_periods_of_service.

36: Date Name Vers Bug No Description
37: -----------+-------------+-------+----------+-------------------------------+
38: 21-Nov-2008 ubhat 120.30. 7584883 Divided locking code for
39: 12010000.3 per_all_assignment_f and
40: per_periods_of_service.
41: 10-Oct-2008 salogana 115.143 7371362 Added bulk delete in
42: trash_latest_balances FOR
43: pay_assignment_latest_balances
44: 05-Aug-2008 salogana 115.142 6595092 Added bulk delete code in

Line 890: from per_periods_of_service POS,

886: p_assact_rec.payroll_id,
887: l_person_id,
888: p_assact_rec.full_name,
889: p_assact_rec.assignment_number
890: from per_periods_of_service POS,
891: per_all_assignments_f ASS,
892: per_all_people_f PEO,
893: pay_assignment_actions ACT
894: where ACT.assignment_action_id = p_assact_rec.assact_id

Line 1041: per_periods_of_service POS

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
1042: where POS.person_id = l_person_id
1043: and ASS.period_of_service_id = POS.period_of_service_id
1044: and ACT.assignment_id = ASS.assignment_id
1045: and ACT.action_sequence > l_action_sequence

Line 1063: per_periods_of_service POS

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
1064: where POS.person_id = l_person_id
1065: and ASS.period_of_service_id = POS.period_of_service_id
1066: and ACT.assignment_id = ASS.assignment_id
1067: and ACT.action_sequence > l_action_sequence

Line 2910: from per_periods_of_service pos,

2906: where lb.person_id = p_person_id;
2907: --
2908: cursor albc (p_person_id number) is
2909: select /*+ ORDERED */ alb.latest_balance_id
2910: from per_periods_of_service pos,
2911: per_all_assignments_f asg,
2912: pay_assignment_actions act,
2913: pay_payroll_actions pac,
2914: pay_assignment_latest_balances alb

Line 4090: posid per_periods_of_service.period_of_service_id%type;

4086: p_mode in varchar2 default 'STANDARD'
4087: ) return number
4088: is
4089: rmode pay_legislation_rules.rule_mode%type;
4090: posid per_periods_of_service.period_of_service_id%type;
4091: actyp pay_payroll_actions.action_type%type;
4092: bgid pay_payroll_actions.business_group_id%type;
4093: l_action_population_status pay_payroll_actions.action_population_status%type;
4094: aa_id number;

Line 4628: from per_periods_of_service pos

4624: if posid is not null then
4625: begin
4626: select 1
4627: into posid
4628: from per_periods_of_service pos
4629: where pos.period_of_service_id = posid
4630: for update of pos.period_of_service_id;
4631: exception
4632: when no_data_found then

Line 4744: per_periods_of_service pos,

4740: pac.effective_date)
4741: from per_business_groups_perf pbg,
4742: per_all_assignments_f asg,
4743: per_all_assignments_f as2,
4744: per_periods_of_service pos,
4745: pay_payroll_actions pac
4746: where pac.payroll_action_id = pactid
4747: and asg.payroll_id = pac.payroll_id
4748: and asg.assignment_id = asgid

Line 4873: per_periods_of_service pos,

4869: from per_business_groups_perf pbg,
4870: pay_assignment_actions act,
4871: pay_payroll_actions pac, -- prepay action.
4872: pay_payroll_actions pa2, -- the QuickPay action.
4873: per_periods_of_service pos,
4874: per_all_assignments_f asg
4875: where pac.payroll_action_id = pactid
4876: and pa2.payroll_action_id = pac.target_payroll_action_id
4877: and act.payroll_action_id = pa2.payroll_action_id