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.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 173: from irc_assignment_statuses ias, per_all_assignments_f asg,

169: l_user_name fnd_user.user_name%type;
170: --
171: cursor csr_ias_del is
172: select ias.assignment_status_id, ias.object_version_number
173: from irc_assignment_statuses ias, per_all_assignments_f asg,
174: per_all_people_f per
175: where asg.assignment_id = ias.assignment_id
176: and asg.person_id = per.person_id
177: and per.party_id = p_party_id;

Line 336: per_all_assignments_f paf,

332: select icm.COMMUNICATION_MESSAGE_ID, icm.OBJECT_VERSION_NUMBER
333: from irc_comm_messages icm,
334: irc_comm_topics ict,
335: irc_communications ic,
336: per_all_assignments_f paf,
337: per_all_people_f ppf
338: where ppf.party_id = p_party_id
339: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
340: and paf.person_id = ppf.person_id

Line 342: from per_all_assignments_f paf1

338: where ppf.party_id = p_party_id
339: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
340: and paf.person_id = ppf.person_id
341: and paf.effective_end_date in (select max(paf1.effective_end_date)
342: from per_all_assignments_f paf1
343: where paf1.assignment_id = paf.assignment_id )
344: and ic.object_id = paf.assignment_id
345: and ict.COMMUNICATION_ID = ic.COMMUNICATION_ID
346: and icm.COMMUNICATION_TOPIC_ID = ict.COMMUNICATION_TOPIC_ID;

Line 355: per_all_assignments_f paf,

351: select icr.COMMUNICATION_RECIPIENT_ID, icr.OBJECT_VERSION_NUMBER
352: from irc_comm_recipients icr,
353: irc_comm_topics ict,
354: irc_communications ic,
355: per_all_assignments_f paf,
356: per_all_people_f ppf
357: where ppf.party_id = p_party_id
358: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
359: and paf.person_id = ppf.person_id

Line 361: from per_all_assignments_f paf1

357: where ppf.party_id = p_party_id
358: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
359: and paf.person_id = ppf.person_id
360: and paf.effective_end_date in (select max(paf1.effective_end_date)
361: from per_all_assignments_f paf1
362: where paf1.assignment_id = paf.assignment_id )
363: and ic.object_id = paf.assignment_id
364: and ict.COMMUNICATION_ID = ic.COMMUNICATION_ID
365: and icr.COMMUNICATION_OBJECT_ID = ict.COMMUNICATION_TOPIC_ID

Line 374: per_all_assignments_f paf,

370: cursor csr_irc_cmt is
371: select ict.COMMUNICATION_TOPIC_ID, ict.OBJECT_VERSION_NUMBER
372: from irc_comm_topics ict,
373: irc_communications ic,
374: per_all_assignments_f paf,
375: per_all_people_f ppf
376: where ppf.party_id = p_party_id
377: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
378: and paf.person_id = ppf.person_id

Line 380: from per_all_assignments_f paf1

376: where ppf.party_id = p_party_id
377: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
378: and paf.person_id = ppf.person_id
379: and paf.effective_end_date in (select max(paf1.effective_end_date)
380: from per_all_assignments_f paf1
381: where paf1.assignment_id = paf.assignment_id )
382: and ic.object_id = paf.assignment_id
383: and ict.COMMUNICATION_ID = ic.COMMUNICATION_ID;
384:

Line 390: per_all_assignments_f paf,

386: ----------------------
387: cursor csr_irc_cmc is
388: select ic.COMMUNICATION_ID, ic.OBJECT_VERSION_NUMBER
389: from irc_communications ic,
390: per_all_assignments_f paf,
391: per_all_people_f ppf
392: where ppf.party_id = p_party_id
393: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
394: and paf.person_id = ppf.person_id

Line 396: from per_all_assignments_f paf1

392: where ppf.party_id = p_party_id
393: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
394: and paf.person_id = ppf.person_id
395: and paf.effective_end_date in (select max(paf1.effective_end_date)
396: from per_all_assignments_f paf1
397: where paf1.assignment_id = paf.assignment_id )
398: and ic.object_id = paf.assignment_id;
399: --
400: begin

Line 720: per_all_assignments_f asg,

716: per_qualifications qua,
717: per_competence_elements pce,
718: irc_job_basket_items jbo,
719: per_all_people_f per1,
720: per_all_assignments_f asg,
721: per_all_people_f per2
722: where per1.person_id=p_person_id
723: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date
724: and per1.party_id = per2.party_id

Line 762: from per_all_assignments_f asg, per_all_people_f per

758: l_max_application_date date := null;
759: --
760: cursor csr_last_application_date is
761: select max(asg.effective_start_date)
762: from per_all_assignments_f asg, per_all_people_f per
763: where per.party_id = p_party_id
764: and p_effective_date
765: between per.effective_start_date and per.effective_end_date
766: and asg.person_id = per.person_id

Line 768: and not exists (select 1 from per_all_assignments_f asg2

764: and p_effective_date
765: between per.effective_start_date and per.effective_end_date
766: and asg.person_id = per.person_id
767: and asg.assignment_type = 'A'
768: and not exists (select 1 from per_all_assignments_f asg2
769: where asg.assignment_id = asg2.assignment_id
770: and asg.effective_start_date > asg2.effective_start_date);
771: --
772: begin