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.HR_DATE_CHK dependencies on PER_ASSIGNMENTS_F

Line 125: from per_assignments_f a

121: cursor pay is
122: select 'pay'
123: from pay_personal_payment_methods_f pa
124: where pa.assignment_id IN (select a.assignment_id
125: from per_assignments_f a
126: where a.assignment_type = 'E'
127: and a.person_id = p_person_id)
128: for update of pa.assignment_id;
129: --

Line 134: from per_assignments_f a

130: cursor ssp is
131: select 'ssp'
132: from per_spinal_point_placements_f sp
133: where assignment_id in (select a.assignment_id
134: from per_assignments_f a
135: where person_id = p_person_id
136: and a.assignment_type = 'E')
137: for update of effective_start_date;
138: --

Line 143: from per_assignments_f a

139: cursor cost is
140: select 'cost'
141: from pay_cost_allocations_f cost
142: where assignment_id in (select a.assignment_id
143: from per_assignments_f a
144: where person_id = p_person_id
145: and a.assignment_type = 'E')
146: for update of effective_start_date;
147: --

Line 150: from per_assignments_f pa

146: for update of effective_start_date;
147: --
148: cursor ass is
149: select 'assignment'
150: from per_assignments_f pa
151: where pa.person_id = p_person_id
152: for update of person_id;
153: cursor app is
154: select 'application'

Line 252: per_assignments_f asg

248: WHERE EXISTS
249: (SELECT NULL
250: FROM pay_payroll_actions pac,
251: pay_assignment_actions act,
252: per_assignments_f asg
253: WHERE asg.person_id = p_person_id
254: AND act.assignment_id = asg.assignment_id
255: AND pac.payroll_action_id = act.payroll_action_id
256: AND pac.action_status = 'C'

Line 321: from per_assignments_f a,

317: -- only need to test the first assignment row
318: --
319: cursor assignment is
320: select a.payroll_id , a.supervisor_id
321: from per_assignments_f a,
322: per_periods_of_service p
323: where a.period_of_service_id = p.period_of_service_id
324: and p.period_of_service_id = p_period_of_service_id
325: and p.date_start = a.effective_start_date;

Line 382: per_assignments_f a

378: from sys.dual
379: where exists (select null
380: from pay_element_entries_f n,
381: per_periods_of_service p,
382: per_assignments_f a
383: where a.person_id = p_person_id
384: and a.period_of_service_id = p_period_of_service_id
385: and p.period_of_service_id = p_period_of_service_id
386: and n.assignment_id = a.assignment_id

Line 411: per_assignments_f a

407: from sys.dual
408: where exists (select 1
409: from per_spinal_point_placements_f sp,
410: per_periods_of_service p,
411: per_assignments_f a
412: where a.person_id = p_person_id
413: and a.period_of_service_id = p_period_of_service_id
414: and p.period_of_service_id = p_period_of_service_id
415: and a.assignment_id = sp.assignment_id

Line 443: per_assignments_f a

439: from sys.dual
440: where exists (select 1
441: from PAY_COST_ALLOCATIONS_F ca,
442: per_periods_of_service p,
443: per_assignments_f a
444: where a.person_id = p_person_id
445: and a.period_of_service_id = p_period_of_service_id
446: and p.period_of_service_id = p_period_of_service_id
447: and a.assignment_id = ca.assignment_id

Line 505: ,per_assignments_f f

501: into v_dummy
502: from sys.dual
503: where exists (select 1
504: from per_assignments a
505: ,per_assignments_f f
506: where f.effective_start_date between p_earlier_date
507: and p_later_date
508: and f.effective_start_date <> p_start_date
509: and f.assignment_id = a.assignment_id

Line 541: from per_assignments_f f

537: select 1
538: into v_dummy
539: from sys.dual
540: where exists (select 1
541: from per_assignments_f f
542: where f.effective_start_date between p_earlier_date
543: and p_later_date
544: and f.effective_start_date <> p_s_start_date
545: -- and f.assignment_type =p_assignment_type

Line 570: from per_assignments_f f

566: select 1
567: into v_dummy
568: from sys.dual
569: where exists (select 1
570: from per_assignments_f f
571: where f.effective_start_date >= p_start_date
572: and f.effective_start_date < p_s_start_date
573: and f.assignment_type =p_assignment_type
574: and f.person_id = p_person_id

Line 704: from per_assignments_f a

700:
701:
702: cursor app_ass is
703: select assignment_id
704: from per_assignments_f a
705: where a.effective_end_date = p_s_start_date - 1
706: and a.assignment_type = 'A'
707: and a.person_id = p_person_id;
708: --

Line 729: from per_assignments_f a

725: cursor ssp is
726: select placement_id
727: from per_spinal_point_placements_f sp
728: where assignment_id in (select a.assignment_id
729: from per_assignments_f a
730: where person_id = p_person_id
731: and a.assignment_type = 'E'
732: and a.effective_start_date = p_s_start_date)
733: and sp.effective_start_date = p_s_start_date;

Line 739: from per_assignments_f a

735: cursor cost is
736: select COST_ALLOCATION_ID
737: from PAY_COST_ALLOCATIONS_F pca
738: where assignment_id in (select a.assignment_id
739: from per_assignments_f a
740: where person_id = p_person_id
741: and a.assignment_type = 'E'
742: and a.effective_start_date = p_s_start_date)
743: and pca.effective_start_date = p_s_start_date;

Line 762: from per_assignments_f a

758: cursor abv is
759: select ASSIGNMENT_BUDGET_VALUE_ID
760: from PER_ASSIGNMENT_BUDGET_VALUES_F abv
761: where assignment_id in (select a.assignment_id
762: from per_assignments_f a
763: where person_id = p_person_id
764: and a.assignment_type = 'E'
765: and a.effective_start_date = p_s_start_date)
766: and abv.effective_start_date = p_s_start_date;

Line 787: from per_assignments_f a

783: set p.effective_start_date = p_start_date
784: where p.effective_start_date = p_s_start_date
785: and p.effective_end_date >= p_start_date
786: and exists (select 1
787: from per_assignments_f a
788: where p.assignment_id = a.assignment_id
789: and a.assignment_type = 'E'
790: and a.person_id = p_person_id);
791: begin

Line 863: update per_assignments_f a

859: --
860: -- BUG 308000 removed select min (effective_date) code
861: -- and it's reference in following code tm 19-sep-1995.
862: --
863: update per_assignments_f a
864: set a.effective_start_date = p_start_date,
865: a.last_update_date = sysdate,
866: a.last_updated_by = p_user_id,
867: a.last_update_login = p_login_id

Line 926: update per_assignments_f a

922: open app_ass;
923: loop
924: fetch app_ass into l_assignment_id;
925: exit when app_ass%NOTFOUND;
926: update per_assignments_f a
927: set a.effective_end_date = p_start_date - 1,
928: a.last_update_date = sysdate,
929: a.last_updated_by = p_user_id,
930: a.last_update_login = p_login_id

Line 933: from per_assignments_f a2

929: a.last_updated_by = p_user_id,
930: a.last_update_login = p_login_id
931: where a.effective_end_date =
932: (select max(a2.effective_end_date)
933: from per_assignments_f a2
934: where a2.assignment_id = a.assignment_id
935: and a2.assignment_type = 'A')
936: and a.assignment_id = l_assignment_id;
937: --

Line 1078: update per_assignments_f a

1074: and a.person_id = p_person_id;
1075: --
1076: --
1077: hr_utility.set_location('hr_date_chk.update_appl_records',2);
1078: update per_assignments_f a
1079: set a.effective_start_date = p_start_date,
1080: a.last_update_date = sysdate,
1081: a.last_updated_by = p_user_id,
1082: a.last_update_login = p_login_id

Line 1088: from per_assignments_f a2

1084: and a.assignment_type = 'A'
1085: and a.person_id = p_person_id
1086: and EXISTS -- #4894555
1087: (select a2.assignment_id
1088: from per_assignments_f a2
1089: where a2.assignment_id = a.assignment_id
1090: and a2.assignment_type = 'A'
1091: group by a2.assignment_id
1092: having max(a2.effective_start_date)= a.effective_start_date);