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_GENERIC_APRV_PVT dependencies on AHL_APPROVERS

Line 1492: -- Takes Min Approver Sequence From Ahl_approvers Once matching records are

1488: FROM ahl_approval_rules_b
1489: WHERE seeded_flag = 'Y'
1490: AND nvl(application_usg_code, l_application_usg_code) = l_application_usg_code;
1491:
1492: -- Takes Min Approver Sequence From Ahl_approvers Once matching records are
1493: -- Found form ahl_approval_rules_b
1494: CURSOR c_approver_seq IS
1495: SELECT min(approver_sequence)
1496: FROM ahl_approvers

Line 1496: FROM ahl_approvers

1492: -- Takes Min Approver Sequence From Ahl_approvers Once matching records are
1493: -- Found form ahl_approval_rules_b
1494: CURSOR c_approver_seq IS
1495: SELECT min(approver_sequence)
1496: FROM ahl_approvers
1497: WHERE approval_rule_id = x_approval_rule_id;
1498:
1499: BEGIN
1500:

Line 1582: FROM ahl_approvers

1578: CURSOR c_approver_info IS
1579: SELECT approval_approver_id,
1580: approver_type_code,
1581: approver_id
1582: FROM ahl_approvers
1583: WHERE approval_rule_id = p_rule_id
1584: AND approver_sequence = p_current_seq;
1585:
1586: CURSOR c_role_info IS

Line 1890: FROM ahl_approvers

1886: IS
1887:
1888: CURSOR c_check_app IS
1889: SELECT approver_sequence
1890: FROM ahl_approvers
1891: WHERE approval_rule_id = p_rule_id
1892: AND approver_sequence > p_current_seq
1893: order by approver_sequence ;
1894: