APPS.HRASSACT dependencies on PER_PERIODS_OF_SERVICE

Line 72: per_periods_of_service.

68: now calling create_all_group_balances
69: after last assignment reversal.
70: 21-Nov-2008 ubhat 115.144 7584883 Divided locking code for
71: per_all_assignment_f and
72: per_periods_of_service.
73: 10-Oct-2008 salogana 115.143 7371362 Added bulk delete in
74: trash_latest_balances FOR
75: pay_assignment_latest_balances
76: 05-Aug-2008 salogana 115.142 6595092 Added bulk delete code in

Line 922: from per_periods_of_service POS,

918: p_assact_rec.payroll_id,
919: l_person_id,
920: p_assact_rec.full_name,
921: p_assact_rec.assignment_number
922: from per_periods_of_service POS,
923: per_all_assignments_f ASS,
924: per_all_people_f PEO,
925: pay_assignment_actions ACT
926: where ACT.assignment_action_id = p_assact_rec.assact_id

Line 1073: per_periods_of_service POS

1069: pay_action_classifications CLAS2,
1070: pay_payroll_actions PACT,
1071: pay_assignment_actions ACT,
1072: per_all_assignments_f ASS,
1073: per_periods_of_service POS
1074: where POS.person_id = l_person_id
1075: and ASS.period_of_service_id = POS.period_of_service_id
1076: and ACT.assignment_id = ASS.assignment_id
1077: and ACT.action_sequence > l_action_sequence

Line 1095: per_periods_of_service POS

1091: pay_action_classifications CLAS2,
1092: pay_payroll_actions PACT,
1093: pay_assignment_actions ACT,
1094: per_all_assignments_f ASS,
1095: per_periods_of_service POS
1096: where POS.person_id = l_person_id
1097: and ASS.period_of_service_id = POS.period_of_service_id
1098: and ACT.assignment_id = ASS.assignment_id
1099: and ACT.action_sequence > l_action_sequence

Line 2927: from per_periods_of_service pos,

2923: where lb.person_id = p_person_id;
2924: --
2925: cursor albc (p_person_id number) is
2926: select /*+ ORDERED */ alb.latest_balance_id
2927: from per_periods_of_service pos,
2928: per_all_assignments_f asg,
2929: pay_assignment_actions act,
2930: pay_payroll_actions pac,
2931: pay_assignment_latest_balances alb

Line 4110: posid per_periods_of_service.period_of_service_id%type;

4106: p_mode in varchar2 default 'STANDARD'
4107: ) return number
4108: is
4109: rmode pay_legislation_rules.rule_mode%type;
4110: posid per_periods_of_service.period_of_service_id%type;
4111: actyp pay_payroll_actions.action_type%type;
4112: bgid pay_payroll_actions.business_group_id%type;
4113: l_action_population_status pay_payroll_actions.action_population_status%type;
4114: aa_id number;

Line 4648: from per_periods_of_service pos

4644: if posid is not null then
4645: begin
4646: select 1
4647: into posid
4648: from per_periods_of_service pos
4649: where pos.period_of_service_id = posid
4650: for update of pos.period_of_service_id;
4651: exception
4652: when no_data_found then

Line 4924: per_periods_of_service pos,

4920: pac.effective_date)
4921: from per_business_groups_perf pbg,
4922: per_all_assignments_f asg,
4923: per_all_assignments_f as2,
4924: per_periods_of_service pos,
4925: pay_payroll_actions pac
4926: where pac.payroll_action_id = pactid
4927: and asg.payroll_id = pac.payroll_id
4928: and asg.assignment_id = asgid

Line 4974: per_periods_of_service pos,

4970: pac.effective_date)
4971: from per_business_groups_perf pbg,
4972: per_all_assignments_f asg,
4973: per_all_assignments_f as2,
4974: per_periods_of_service pos,
4975: pay_payroll_actions pac
4976: where pac.payroll_action_id = pactid
4977: and asg.payroll_id = pac.payroll_id
4978: and asg.assignment_id = asgid

Line 5105: per_periods_of_service pos,

5101: from per_business_groups_perf pbg,
5102: pay_assignment_actions act,
5103: pay_payroll_actions pac, -- prepay action.
5104: pay_payroll_actions pa2, -- the QuickPay action.
5105: per_periods_of_service pos,
5106: per_all_assignments_f asg
5107: where pac.payroll_action_id = pactid
5108: and pa2.payroll_action_id = pac.target_payroll_action_id
5109: and act.payroll_action_id = pa2.payroll_action_id