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 525: from per_all_assignments_f asg,

521: adrr.address_line1 || adrr.address_line2 || adrr.address_line3), 1, 240)) address_kanji,
522: decode(adrr.address_id, null, adrc.country, adrr.country) country,
523: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
524: asg.organization_id
525: from per_all_assignments_f asg,
526: per_all_people_f per,
527: per_addresses adrr,
528: per_addresses adrc
529: where asg.assignment_id = cp_assignment_id

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

667: BEGIN
668: --
669: hr_utility.set_location('Entering: ' || c_proc, 10);
670: --
671: -- Lock first(not latest) record on PER_ALL_ASSIGNMENTS_F
672: -- to suppress other PAYJPITW processes archive the same information
673: -- at the same time.
674: --
675: select asg.assignment_id

Line 678: per_all_assignments_f asg

674: --
675: select asg.assignment_id
676: into l_assignment_id
677: from pay_assignment_actions paa,
678: per_all_assignments_f asg
679: where paa.assignment_action_id = p_assignment_action_id
680: and asg.assignment_id = paa.assignment_id
681: and asg.effective_start_date <= g_effective_date
682: and asg.effective_end_date >= g_soy

Line 685: from per_all_assignments_f asg2

681: and asg.effective_start_date <= g_effective_date
682: and asg.effective_end_date >= g_soy
683: and not exists(
684: select null
685: from per_all_assignments_f asg2
686: where asg2.assignment_id = asg.assignment_id
687: and asg2.effective_start_date < asg.effective_start_date
688: and asg2.effective_end_date >= g_soy)
689: for update of asg.assignment_id nowait;