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.AHL_SB_RULES_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 55: FROM AHL_UNIT_CONFIG_HEADERS

51:
52: -- cursor to check the unit header id
53: CURSOR chk_unit_header_id_csr (c_uc_header_id NUMBER) IS
54: SELECT name
55: FROM AHL_UNIT_CONFIG_HEADERS
56: WHERE unit_config_header_id = c_uc_header_id
57: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
58: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
59:

Line 72: AHL_UNIT_CONFIG_HEADERS UC

68: SELECT SB.rule_id,
69: SB.rule_name,
70: SB.relationship_id
71: FROM AHL_SB_POSITION_RULES SB,
72: AHL_UNIT_CONFIG_HEADERS UC
73: WHERE UC.unit_config_header_id = c_uc_header_id
74: AND SB.mc_header_id = UC.master_config_id
75: -- take only the rules which have MRs accomplished on the unit
76: AND EXISTS (SELECT 'X'

Line 100: AHL_UNIT_CONFIG_HEADERS UC

96: SELECT SB.rule_id,
97: SB.rule_name,
98: SB.relationship_id
99: FROM AHL_SB_POSITION_RULES SB,
100: AHL_UNIT_CONFIG_HEADERS UC
101: WHERE UC.unit_config_header_id = c_uc_header_id
102: AND SB.mc_header_id = UC.master_config_id
103: -- take only the rules which have MRs accomplished on the unit
104: AND EXISTS (SELECT 'X'

Line 126: AHL_UNIT_CONFIG_HEADERS UC

122: SB.rule_name,
123: SB.relationship_id
124: FROM AHL_SB_POSITION_RULES SB,
125: AHL_VISIT_TASKS_B VT,
126: AHL_UNIT_CONFIG_HEADERS UC
127: WHERE UC.unit_config_header_id = c_uc_header_id
128: AND SB.mc_header_id = UC.master_config_id
129: -- take only the rules which have MRs attached to the visit
130: AND VT.visit_id = c_visit_id

Line 375: FROM AHL_UNIT_CONFIG_HEADERS

371:
372: -- cursor to get the name of the given unit
373: CURSOR get_unit_name_csr (c_uc_header_id NUMBER) IS
374: SELECT name
375: FROM AHL_UNIT_CONFIG_HEADERS
376: WHERE unit_config_header_id = c_uc_header_id
377: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
378: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
379:

Line 387: AHL_UNIT_CONFIG_HEADERS UC

383: SELECT SB.rule_id,
384: SB.rule_name,
385: SB.relationship_id
386: FROM AHL_SB_POSITION_RULES SB,
387: AHL_UNIT_CONFIG_HEADERS UC
388: WHERE UC.unit_config_header_id = c_uc_header_id
389: AND SB.mc_header_id = UC.master_config_id
390: -- take only the rules which have MRs accomplished on the unit
391: AND EXISTS (SELECT 'X'

Line 647: FROM AHL_UNIT_CONFIG_HEADERS

643: CURSOR get_unit_det_csr (c_uc_header_id NUMBER,
644: c_mc_header_id NUMBER) IS
645: SELECT unit_config_header_id,
646: name
647: FROM AHL_UNIT_CONFIG_HEADERS
648: WHERE master_config_id = c_mc_header_id
649: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
650: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
651: AND unit_config_header_id IN (SELECT unit_config_header_id

Line 652: FROM AHL_UNIT_CONFIG_HEADERS

648: WHERE master_config_id = c_mc_header_id
649: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
650: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
651: AND unit_config_header_id IN (SELECT unit_config_header_id
652: FROM AHL_UNIT_CONFIG_HEADERS
653: START WITH unit_config_header_id = c_uc_header_id
654: CONNECT BY parent_uc_header_id = PRIOR unit_config_header_id);
655:
656: -- cursor to get applicable SB rules for the given unit and position

Line 662: AHL_UNIT_CONFIG_HEADERS UC

658: c_relationship_id NUMBER) IS
659: SELECT SB.rule_id,
660: SB.rule_name
661: FROM AHL_SB_POSITION_RULES SB,
662: AHL_UNIT_CONFIG_HEADERS UC
663: WHERE UC.unit_config_header_id = c_uc_header_id
664: AND SB.mc_header_id = UC.master_config_id
665: -- take only the rules which have MRs accomplished on the unit
666: AND EXISTS (SELECT 'X'

Line 1038: FROM AHL_UNIT_CONFIG_HEADERS

1034:
1035: -- cursor to get the MC header id for a unit
1036: CURSOR get_mc_header_id_csr (c_uc_header_id NUMBER) IS
1037: SELECT master_config_id
1038: FROM AHL_UNIT_CONFIG_HEADERS
1039: WHERE unit_config_header_id = c_uc_header_id;
1040:
1041: -- cursor to get the MC header ids for the SB rules defined for a given MR
1042: CURSOR get_sb_mc_header_id_csr (c_mr_header_id NUMBER) IS

Line 1674: FROM AHL_UNIT_CONFIG_HEADERS

1670:
1671: -- cursor to check the unit header id
1672: CURSOR chk_unit_header_id_csr (c_uc_header_id NUMBER) IS
1673: SELECT 'X'
1674: FROM AHL_UNIT_CONFIG_HEADERS
1675: WHERE unit_config_header_id = c_uc_header_id
1676: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
1677: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
1678:

Line 1684: AHL_UNIT_CONFIG_HEADERS UC

1680: CURSOR get_appl_sb_rules_csr (c_uc_header_id NUMBER) IS
1681: SELECT SB.rule_id,
1682: SB.relationship_id
1683: FROM AHL_SB_POSITION_RULES SB,
1684: AHL_UNIT_CONFIG_HEADERS UC
1685: WHERE UC.unit_config_header_id = c_uc_header_id
1686: AND SB.mc_header_id = UC.master_config_id
1687: -- take only the rules which have MRs accomplished on the unit
1688: AND EXISTS (SELECT 'X'

Line 1905: FROM AHL_UNIT_CONFIG_HEADERS

1901:
1902: -- cursor to get the MC header id for a unit
1903: CURSOR get_mc_header_id_csr (c_uc_header_id NUMBER) IS
1904: SELECT master_config_id
1905: FROM AHL_UNIT_CONFIG_HEADERS
1906: WHERE unit_config_header_id = c_uc_header_id;
1907:
1908: --
1909: l_api_version CONSTANT NUMBER := 1.0;