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_ALL_ASSIGNMENTS_F

Line 654: assignment_number per_all_assignments_f.assignment_number%type,

650: type assact_details is record
651: (assact_id pay_assignment_actions.assignment_action_id%type,
652: assignment_id pay_assignment_actions.assignment_id%type,
653: full_name per_all_people_f.full_name%type,
654: assignment_number per_all_assignments_f.assignment_number%type,
655: payroll_id per_all_assignments_f.payroll_id%type);
656: --
657: type pact_details is record
658: (pact_id pay_payroll_actions.payroll_action_id%type,

Line 655: payroll_id per_all_assignments_f.payroll_id%type);

651: (assact_id pay_assignment_actions.assignment_action_id%type,
652: assignment_id pay_assignment_actions.assignment_id%type,
653: full_name per_all_people_f.full_name%type,
654: assignment_number per_all_assignments_f.assignment_number%type,
655: payroll_id per_all_assignments_f.payroll_id%type);
656: --
657: type pact_details is record
658: (pact_id pay_payroll_actions.payroll_action_id%type,
659: action_name hr_lookups.meaning%type,

Line 923: per_all_assignments_f ASS,

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
927: and ASS.assignment_id = ACT.assignment_id

Line 1072: per_all_assignments_f ASS,

1068: from pay_action_classifications CLASS,
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

Line 1094: per_all_assignments_f ASS,

1090: from pay_action_classifications CLASS,
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

Line 2928: per_all_assignments_f asg,

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
2932: where pos.person_id = p_person_id

Line 2982: from per_all_assignments_f asg

2978: pay_input_values_f piv
2979: where act.assignment_id = alb.assignment_id
2980: and alb.assignment_id in
2981: (select distinct asg.assignment_id
2982: from per_all_assignments_f asg
2983: where asg.person_id = p_person_id)
2984: and alb.assignment_action_id = act.assignment_action_id
2985: and piv.element_type_id = p_eletyp_id
2986: and piv.input_value_id = pbf.input_value_id

Line 3030: from per_all_assignments_f asg

3026: hr_utility.set_location('hrassact.del_latest_balances',10);
3027: end if;
3028: select asg.person_id
3029: into l_person_id
3030: from per_all_assignments_f asg
3031: where asg.assignment_id = p_assignment_id
3032: and p_effective_date between
3033: asg.effective_start_date and asg.effective_end_date;
3034: --

Line 3263: per_all_assignments_f asg,

3259: ac2.rowid,
3260: ac2.assignment_action_id
3261: from pay_assignment_actions act,
3262: pay_payroll_actions pac,
3263: per_all_assignments_f asg,
3264: per_all_assignments_f as2,
3265: pay_assignment_actions ac2,
3266: pay_payroll_actions pa2,
3267: pay_action_classifications acl

Line 3264: per_all_assignments_f as2,

3260: ac2.assignment_action_id
3261: from pay_assignment_actions act,
3262: pay_payroll_actions pac,
3263: per_all_assignments_f asg,
3264: per_all_assignments_f as2,
3265: pay_assignment_actions ac2,
3266: pay_payroll_actions pa2,
3267: pay_action_classifications acl
3268: where act.assignment_action_id = aaid

Line 3278: from per_all_assignments_f paf3

3274: and as2.effective_end_date > pac.effective_date
3275: and ac2.assignment_id = as2.assignment_id
3276: and pa2.payroll_action_id = ac2.payroll_action_id
3277: and as2.effective_start_date = (select max(paf3.effective_start_date)
3278: from per_all_assignments_f paf3
3279: where paf3.assignment_id = ac2.assignment_id
3280: and paf3.effective_start_date <= pa2.effective_date
3281: )
3282: and acl.classification_name = 'SEQUENCED'

Line 3568: per_all_assignments_f asg,

3564: ac2.assignment_action_id,
3565: ac2.source_action_id,
3566: ac2.object_type
3567: from pay_payroll_actions pac,
3568: per_all_assignments_f asg,
3569: per_all_assignments_f as2,
3570: pay_assignment_actions act,
3571: pay_assignment_actions ac2,
3572: pay_payroll_actions pa2,

Line 3569: per_all_assignments_f as2,

3565: ac2.source_action_id,
3566: ac2.object_type
3567: from pay_payroll_actions pac,
3568: per_all_assignments_f asg,
3569: per_all_assignments_f as2,
3570: pay_assignment_actions act,
3571: pay_assignment_actions ac2,
3572: pay_payroll_actions pa2,
3573: pay_action_classifications acl

Line 3587: from per_all_assignments_f paf3

3583: as2.effective_end_date) >= pac.effective_date
3584: and ac2.assignment_id = as2.assignment_id
3585: and pa2.payroll_action_id = ac2.payroll_action_id
3586: and as2.effective_start_date = (select max(paf3.effective_start_date)
3587: from per_all_assignments_f paf3
3588: where paf3.assignment_id = ac2.assignment_id
3589: )
3590: and acl.classification_name = 'SEQUENCED'
3591: and pa2.action_type = acl.action_type

Line 4186: per_all_assignments_f asg,

4182: ac2.rowid,
4183: ac2.assignment_action_id
4184: from pay_payroll_actions pac,
4185: pay_assignment_actions act,
4186: per_all_assignments_f asg,
4187: per_all_assignments_f as2,
4188: pay_assignment_actions ac2,
4189: pay_payroll_actions pa2,
4190: pay_action_classifications acl

Line 4187: per_all_assignments_f as2,

4183: ac2.assignment_action_id
4184: from pay_payroll_actions pac,
4185: pay_assignment_actions act,
4186: per_all_assignments_f asg,
4187: per_all_assignments_f as2,
4188: pay_assignment_actions ac2,
4189: pay_payroll_actions pa2,
4190: pay_action_classifications acl
4191: where pac.payroll_action_id = pactid

Line 4287: from per_all_assignments_f paf

4283: for update of ac2.assignment_action_id;
4284: --
4285: cursor perasg (persid number) is
4286: select distinct paf.assignment_id
4287: from per_all_assignments_f paf
4288: where paf.person_id = persid;
4289: --
4290: cursor perobj (asgid number) is
4291: select distinct pog_grp.source_id assignment_id

Line 4336: per_all_assignments_f asg,

4332: asg.person_id
4333: into effdate, actype, lgcode, persid
4334: from
4335: per_business_groups_perf pbg,
4336: per_all_assignments_f asg,
4337: pay_payroll_actions pac
4338: where pac.payroll_action_id = pactid
4339: and pbg.business_group_id = asg.business_group_id
4340: and asg.assignment_id = asgid

Line 4553: -- join to per_all_assignments_f.

4549: -- We do not attempt a correlated update, since we
4550: -- need to aquire and hold locks on all the rows.
4551: -- NOTE - the update of sequences for 'X' actions will
4552: -- work correctly because the seqasg cursor does not
4553: -- join to per_all_assignments_f.
4554: if g_debug then
4555: hr_utility.set_location('hrassact.irbaact',30);
4556: end if;
4557: if(rmode = 'Y') then

Line 4637: per_all_assignments_f asg

4633: asg.business_group_id,
4634: asg.period_of_service_id
4635: into bgid, posid
4636: from pay_payroll_actions pac,
4637: per_all_assignments_f asg
4638: where pac.payroll_action_id = pactid
4639: and asg.assignment_id = asgid
4640: and pac.effective_date between
4641: asg.effective_start_date and asg.effective_end_date

Line 4716: per_all_assignments_f asg,

4712: hr_dynsql.get_tax_unit(asg.assignment_id,
4713: pac.effective_date)
4714: from
4715: per_business_groups_perf pbg,
4716: per_all_assignments_f asg,
4717: per_all_assignments_f as2,
4718: pay_payroll_actions pac
4719: where pac.payroll_action_id = pactid
4720: and asg.payroll_id = pac.payroll_id

Line 4717: per_all_assignments_f as2,

4713: pac.effective_date)
4714: from
4715: per_business_groups_perf pbg,
4716: per_all_assignments_f asg,
4717: per_all_assignments_f as2,
4718: pay_payroll_actions pac
4719: where pac.payroll_action_id = pactid
4720: and asg.payroll_id = pac.payroll_id
4721: and asg.assignment_id = asgid

Line 4760: per_all_assignments_f asg,

4756: hr_dynsql.get_tax_unit(asg.assignment_id,
4757: pac.effective_date)
4758: from
4759: per_business_groups_perf pbg,
4760: per_all_assignments_f asg,
4761: per_all_assignments_f as2,
4762: pay_payroll_actions pac
4763: where pac.payroll_action_id = pactid
4764: and asg.payroll_id = pac.payroll_id

Line 4761: per_all_assignments_f as2,

4757: pac.effective_date)
4758: from
4759: per_business_groups_perf pbg,
4760: per_all_assignments_f asg,
4761: per_all_assignments_f as2,
4762: pay_payroll_actions pac
4763: where pac.payroll_action_id = pactid
4764: and asg.payroll_id = pac.payroll_id
4765: and asg.assignment_id = asgid

Line 4811: per_all_assignments_f asg,

4807: 1,
4808: hr_dynsql.get_tax_unit(asg.assignment_id,
4809: pac.effective_date)
4810: from per_business_groups_perf pbg,
4811: per_all_assignments_f asg,
4812: per_all_assignments_f as2,
4813: pay_object_groups pog,
4814: pay_payroll_actions pac
4815: where pac.payroll_action_id = pactid

Line 4812: per_all_assignments_f as2,

4808: hr_dynsql.get_tax_unit(asg.assignment_id,
4809: pac.effective_date)
4810: from per_business_groups_perf pbg,
4811: per_all_assignments_f asg,
4812: per_all_assignments_f as2,
4813: pay_object_groups pog,
4814: pay_payroll_actions pac
4815: where pac.payroll_action_id = pactid
4816: and asg.payroll_id = pac.payroll_id

Line 4862: per_all_assignments_f asg,

4858: 1,
4859: hr_dynsql.get_tax_unit(asg.assignment_id,
4860: pac.effective_date)
4861: from per_business_groups_perf pbg,
4862: per_all_assignments_f asg,
4863: per_all_assignments_f as2,
4864: pay_object_groups pog,
4865: pay_payroll_actions pac
4866: where pac.payroll_action_id = pactid

Line 4863: per_all_assignments_f as2,

4859: hr_dynsql.get_tax_unit(asg.assignment_id,
4860: pac.effective_date)
4861: from per_business_groups_perf pbg,
4862: per_all_assignments_f asg,
4863: per_all_assignments_f as2,
4864: pay_object_groups pog,
4865: pay_payroll_actions pac
4866: where pac.payroll_action_id = pactid
4867: and asg.payroll_id = pac.payroll_id

Line 4922: per_all_assignments_f asg,

4918: 1,
4919: hr_dynsql.get_tax_unit(asg.assignment_id,
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

Line 4923: per_all_assignments_f as2,

4919: hr_dynsql.get_tax_unit(asg.assignment_id,
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

Line 4941: per_all_assignments_f as2,

4937: select /*+ INDEX (pa2 PAY_PAYROLL_ACTIONS_PK)
4938: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4939: from pay_assignment_actions ac2,
4940: pay_payroll_actions pa2,
4941: per_all_assignments_f as2,
4942: per_time_periods ptp
4943: where as2.period_of_service_id = pos.period_of_service_id
4944: and ac2.assignment_id = as2.assignment_id
4945: and pa2.payroll_action_id = ac2.payroll_action_id

Line 4972: per_all_assignments_f asg,

4968: 1,
4969: hr_dynsql.get_tax_unit(asg.assignment_id,
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

Line 4973: per_all_assignments_f as2,

4969: hr_dynsql.get_tax_unit(asg.assignment_id,
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

Line 4992: per_all_assignments_f as2

4988: INDEX (ac2 PAY_ASSIGNMENT_ACTIONS_N1) */ null
4989: from pay_action_classifications acl,
4990: pay_assignment_actions ac2,
4991: pay_payroll_actions pa2,
4992: per_all_assignments_f as2
4993: where as2.period_of_service_id = pos.period_of_service_id
4994: and ac2.assignment_id = as2.assignment_id
4995: and pa2.payroll_action_id = ac2.payroll_action_id
4996: and acl.classification_name = 'SEQUENCED'

Line 5106: per_all_assignments_f asg

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
5110: and act.source_action_id is null /* master assignment action */

Line 5127: from per_all_assignments_f as3,

5123: and pa3.payroll_action_id = ac2.payroll_action_id
5124: and pa3.action_type in ('P', 'U'))
5125: and not exists (
5126: select null
5127: from per_all_assignments_f as3,
5128: pay_assignment_actions ac3
5129: where rmode <> 'Y'
5130: and ac3.payroll_action_id = pa2.payroll_action_id
5131: and ac3.action_status not in ('C', 'S')

Line 6735: per_all_assignments_f asg,

6731: creatby,
6732: creatdate,
6733: l_original_entry_id
6734: from pay_element_entries_f pee,
6735: per_all_assignments_f asg,
6736: per_time_periods ptp,
6737: per_business_groups_perf pbg
6738: where pee.element_entry_id = eentryid
6739: and effdate between

Line 7131: asgid per_all_assignments_f.assignment_id%TYPE;

7127: bal_dims bal_dims_cache;
7128:
7129: c_indent constant varchar2(30) := 'hrassact.maintain_lat_bal';
7130: pactid pay_payroll_actions.payroll_action_id%TYPE;
7131: asgid per_all_assignments_f.assignment_id%TYPE;
7132: bus_grp_id per_all_assignments_f.business_group_id%TYPE;
7133: l_person_id per_all_assignments_f.person_id%TYPE;
7134: cxt_id number;
7135: tax_unit_id number;

Line 7132: bus_grp_id per_all_assignments_f.business_group_id%TYPE;

7128:
7129: c_indent constant varchar2(30) := 'hrassact.maintain_lat_bal';
7130: pactid pay_payroll_actions.payroll_action_id%TYPE;
7131: asgid per_all_assignments_f.assignment_id%TYPE;
7132: bus_grp_id per_all_assignments_f.business_group_id%TYPE;
7133: l_person_id per_all_assignments_f.person_id%TYPE;
7134: cxt_id number;
7135: tax_unit_id number;
7136: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;

Line 7133: l_person_id per_all_assignments_f.person_id%TYPE;

7129: c_indent constant varchar2(30) := 'hrassact.maintain_lat_bal';
7130: pactid pay_payroll_actions.payroll_action_id%TYPE;
7131: asgid per_all_assignments_f.assignment_id%TYPE;
7132: bus_grp_id per_all_assignments_f.business_group_id%TYPE;
7133: l_person_id per_all_assignments_f.person_id%TYPE;
7134: cxt_id number;
7135: tax_unit_id number;
7136: bal_dim_name pay_balance_dimensions.dimension_name%TYPE;
7137: balance_expiry_code pay_balance_dimensions.expiry_checking_code%TYPE;

Line 8418: per_all_assignments_f pera

8414: pactid,
8415: tax_unit_id,
8416: bus_grp_id
8417: from pay_assignment_actions paa,
8418: per_all_assignments_f pera
8419: where paa.assignment_action_id = assactid
8420: and pera.assignment_id = paa.assignment_id
8421: and effdate between pera.effective_start_date
8422: and pera.effective_end_date;

Line 8683: FROM per_all_assignments_f

8679:
8680: begin
8681: SELECT business_group_id
8682: into v_business_group_id
8683: FROM per_all_assignments_f
8684: WHERE assignment_id = p_assignment_id
8685: AND p_effective_date BETWEEN effective_start_date AND effective_end_date ;
8686: exception
8687: when no_data_found then