APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 181: -- Performance against multiple records of PER_ALL_ASSIGNMENTS_F with the same ASSIGNMENT_ID

177: -- This will be changed "1 assignment action for each certificate"
178: -- in next major release.
179: --
180: -- This archive process not only archives data but also validates existing archive data.
181: -- Performance against multiple records of PER_ALL_ASSIGNMENTS_F with the same ASSIGNMENT_ID
182: -- can be ignored because "exists" validation is performed only once for each ASSIGNMENT_ID.
183: --
184: -- Cursor is changed not to check archive data as follows.
185: -- Assignment action is created for each assignment returned by view

Line 195: from per_all_assignments_f asg

191: --
192: cursor csr_asg is
193: select distinct
194: asg.assignment_id
195: from per_all_assignments_f asg
196: where asg.person_id
197: between p_start_person_id and p_end_person_id
198: and asg.business_group_id + 0 = g_business_group_id
199: and asg.assignment_type = 'E'

Line 516: from per_all_assignments_f asg,

512: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address_kanji,
513: decode(adrr.address_id, null, adrc.country, adrr.country) country,
514: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
515: asg.organization_id
516: from per_all_assignments_f asg,
517: per_all_people_f per,
518: per_addresses adrr,
519: per_addresses adrc
520: where asg.assignment_id = cp_assignment_id

Line 657: -- Lock first(not latest) record on PER_ALL_ASSIGNMENTS_F

653: end delete_archive;
654: BEGIN
655: hr_utility.set_location('Entering: ' || c_proc, 10);
656: --
657: -- Lock first(not latest) record on PER_ALL_ASSIGNMENTS_F
658: -- to suppress other PAYJPITW processes archive the same information
659: -- at the same time.
660: --
661: select asg.assignment_id

Line 664: per_all_assignments_f asg

660: --
661: select asg.assignment_id
662: into l_assignment_id
663: from pay_assignment_actions paa,
664: per_all_assignments_f asg
665: where paa.assignment_action_id = p_assignment_action_id
666: and asg.assignment_id = paa.assignment_id
667: and asg.effective_start_date <= g_effective_date
668: and asg.effective_end_date >= g_soy

Line 671: from per_all_assignments_f asg2

667: and asg.effective_start_date <= g_effective_date
668: and asg.effective_end_date >= g_soy
669: and not exists(
670: select null
671: from per_all_assignments_f asg2
672: where asg2.assignment_id = asg.assignment_id
673: and asg2.effective_start_date < asg.effective_start_date
674: and asg2.effective_end_date >= g_soy)
675: for update of asg.assignment_id nowait;