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_APPLICATIONS_PKG dependencies on PER_LETTER_GEN_STATUSES

Line 379: FROM PER_LETTER_GEN_STATUSES PLG

375: P_dummy_asg_stat_id NUMBER) IS
376:
377: CURSOR c_letter_stat_exists IS
378: SELECT 1
379: FROM PER_LETTER_GEN_STATUSES PLG
380: WHERE PLG.business_group_id + 0 = p_business_group_id
381: AND PLG.ASSIGNMENT_STATUS_TYPE_ID = P_dummy_asg_stat_id
382: AND PLG.ENABLED_FLAG = 'Y';
383:

Line 475: FROM per_letter_gen_statuses s

471: p_assignment_status_type_id NUMBER ) IS
472:
473: CURSOR ck_gen_stats IS
474: SELECT 1
475: FROM per_letter_gen_statuses s
476: WHERE S.business_group_id + 0 = P_business_group_id
477: AND s.assignment_status_type_id = p_assignment_status_type_id
478: AND s.enabled_flag = 'Y';
479:

Line 485: PER_LETTER_GEN_STATUSES s

481: CURSOR csr_let_req IS
482: SELECT R.LETTER_REQUEST_ID,
483: r.letter_type_id
484: FROM PER_LETTER_REQUESTS R,
485: PER_LETTER_GEN_STATUSES s
486: WHERE r.business_group_id + 0 = p_business_group_id
487: AND s.business_group_id + 0 = p_business_group_id
488: AND r.LETTER_TYPE_ID = S.LETTER_TYPE_ID
489: AND s.ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id

Line 496: FROM per_letter_gen_statuses s

492: AND R.AUTO_OR_MANUAL = 'AUTO';
493:
494: CURSOR test_new_req IS
495: SELECT 1
496: FROM per_letter_gen_statuses s
497: WHERE S.business_group_id + 0 = P_business_group_id
498: AND s.assignment_status_type_id = p_assignment_status_type_id
499: AND s.enabled_flag = 'Y'
500: AND NOT EXISTS

Line 510: FROM per_letter_gen_statuses s

506: AND r.auto_or_manual = 'AUTO');
507:
508: CURSOR csr_letter_type IS
509: SELECT distinct(s.letter_type_id)
510: FROM per_letter_gen_statuses s
511: WHERE s.business_group_id + 0 = p_business_group_id
512: AND s.assignment_status_type_id = p_assignment_status_type_id
513: AND s.enabled_flag = 'Y'
514: AND s.letter_type_id NOT IN (SELECT distinct(r.letter_type_id)

Line 539: PER_LETTER_GEN_STATUSES PLGS

535: --
536: CURSOR csr_check_manual_or_auto IS
537: SELECT 1
538: FROM PER_LETTER_REQUESTS PLR,
539: PER_LETTER_GEN_STATUSES PLGS
540: WHERE PLGS.business_group_id + 0 = p_business_group_id
541: AND PLR.business_group_id +0 = p_business_group_id
542: AND PLGS.assignment_status_type_id = p_assignment_status_type_id
543: AND PLR.letter_type_id = PLGS.letter_type_id

Line 606: , PER_LETTER_GEN_STATUSES s

602: , p_last_update_login
603: , p_last_updated_by
604: , trunc(SYSDATE)
605: FROM PER_LETTER_REQUESTS r
606: , PER_LETTER_GEN_STATUSES s
607: , PER_ASSIGNMENTS a
608: WHERE R.LETTER_TYPE_ID = S.LETTER_TYPE_ID
609: AND R.LETTER_TYPE_ID = v_letter_type
610: AND R.letter_request_id = v_letter_request_id -- Added for bug3680947.

Line 703: , PER_LETTER_GEN_STATUSES s

699: , p_last_update_login
700: , p_last_updated_by
701: , trunc(SYSDATE)
702: FROM PER_LETTER_REQUESTS R
703: , PER_LETTER_GEN_STATUSES s
704: WHERE R.LETTER_TYPE_ID = S.LETTER_TYPE_ID
705: AND p_assignment_status_type_id = S.ASSIGNMENT_STATUS_TYPE_ID
706: AND S.business_group_id + 0 = R.business_group_id + 0
707: AND S.BUSINESS_GROUP_ID + 0 = P_Business_group_id

Line 752: FROM per_letter_gen_statuses s

748: ) IS
749:
750: CURSOR c_term_apl_stat IS
751: SELECT 1
752: FROM per_letter_gen_statuses s
753: , per_assignment_status_types a
754: WHERE s.business_group_id + 0 = p_business_group_id
755: AND a.assignment_status_type_id = s.assignment_status_type_id
756: AND a.per_system_status = 'TERM_APL'

Line 774: PER_LETTER_GEN_STATUSES s,

770:
771: CURSOR csr_let_req_id IS
772: SELECT r.letter_request_id
773: FROM PER_LETTER_REQUESTS R,
774: PER_LETTER_GEN_STATUSES s,
775: PER_ASSIGNMENT_STATUS_TYPES T
776: WHERE r.business_group_id + 0 = p_business_group_id
777: AND s.business_group_id + 0 = p_business_group_id
778: AND r.LETTER_TYPE_ID = S.LETTER_TYPE_ID

Line 788: PER_LETTER_GEN_STATUSES s,

784:
785: CURSOR csr_odd_reqs IS
786: SELECT R.LETTER_REQUEST_ID
787: FROM PER_LETTER_REQUESTS R,
788: PER_LETTER_GEN_STATUSES s,
789: PER_ASSIGNMENT_STATUS_TYPES T
790: WHERE r.business_group_id + 0 = p_business_group_id
791: AND s.business_group_id + 0 = p_business_group_id
792: AND r.LETTER_TYPE_ID = S.LETTER_TYPE_ID