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.PER_EVENTS_PKG dependencies on PER_LETTER_GEN_STATUSES

Line 347: from per_letter_gen_statuses s

343: p_assignment_id number) is
344: --
345: cursor csr_check_letter is
346: select null
347: from per_letter_gen_statuses s
348: where s.business_group_id + 0 = p_business_group_id
349: and s.assignment_status_type_id = p_ASSIGNMENT_STATUS_TYPE_ID
350: and s.enabled_flag = 'Y';
351:

Line 364: PER_LETTER_GEN_STATUSES PLGS

360: --fix for bug 7019343 starts here.
361: CURSOR csr_check_manual_or_auto IS
362: SELECT 1
363: FROM PER_LETTER_REQUESTS PLR,
364: PER_LETTER_GEN_STATUSES PLGS
365: WHERE PLGS.business_group_id + 0 = p_business_group_id
366: AND PLR.business_group_id +0 = p_business_group_id
367: AND PLGS.assignment_status_type_id = p_assignment_status_type_id
368: AND PLR.letter_type_id = PLGS.letter_type_id

Line 426: from per_letter_gen_statuses s

422: , p_login_id
423: , p_user
424: , sysdate
425: , l_vacancy_id
426: from per_letter_gen_statuses s
427: where s.business_group_id + 0 = p_business_group_id
428: and s.assignment_status_type_id = p_assignment_status_type_id
429: and s.enabled_flag = 'Y'
430: and not exists

Line 474: from per_letter_gen_statuses s

470: , sysdate
471: from per_letter_requests r
472: where exists
473: (select null
474: from per_letter_gen_statuses s
475: where s.letter_type_id = r.letter_type_id
476: and s.business_group_id + 0 = p_business_group_id
477: and s.business_group_id + 0 = r.business_group_id + 0
478: and s.assignment_status_type_id =

Line 519: from per_letter_gen_statuses s

515: , p_login_id
516: , p_user
517: , sysdate
518: , l_vacancy_id
519: from per_letter_gen_statuses s
520: where s.business_group_id + 0 = p_business_group_id
521: and s.assignment_status_type_id = p_assignment_status_type_id
522: and s.enabled_flag = 'Y'
523: and not exists

Line 567: from per_letter_gen_statuses s

563: , sysdate
564: from per_letter_requests r
565: where exists
566: (select null
567: from per_letter_gen_statuses s
568: where s.letter_type_id = r.letter_type_id
569: and s.business_group_id + 0 = p_business_group_id
570: and s.business_group_id + 0 = r.business_group_id + 0
571: and s.assignment_status_type_id =