APPS.AMS_APPROVAL_PVT dependencies on DUAL

Line 1076: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1072: CURSOR c_role_info IS
1073: SELECT rr.role_resource_id, rl.role_name
1074: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
1075: WHERE rr.role_id = rl.role_id
1076: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1077: AND rr.delete_flag = 'N'
1078: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
1079: AND rl.role_type_code in ( 'MKTGAPPR', 'AMSAPPR')
1080: AND rl.role_id = l_approver_id;

Line 1088: AND role_resource_type = 'RS_INDIVIDUAL'

1084: , role_name
1085: FROM jtf_rs_defresroles_vl
1086: WHERE role_type_code IN ('MKTGAPPR','AMSAPPR')
1087: AND role_id = l_approver_id
1088: AND role_resource_type = 'RS_INDIVIDUAL'
1089: AND delete_flag = 'N'
1090: AND TRUNC(SYSDATE) BETWEEN TRUNC(res_rl_start_date)
1091: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1092: */

Line 1097: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1093: CURSOR c_role_info_count IS
1094: SELECT COUNT(1)
1095: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1096: WHERE rr.role_id = rl.role_id
1097: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1098: AND rr.delete_flag = 'N'
1099: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
1100: AND rl.role_type_code in ( 'MKTGAPPR', 'AMSAPPR')
1101: AND rl.role_id = l_approver_id;

Line 1108: AND role_resource_type = 'RS_INDIVIDUAL'

1104: SELECT COUNT(1)
1105: FROM jtf_rs_defresroles_vl
1106: WHERE role_type_code IN ('MKTGAPPR','AMSAPPR')
1107: AND role_id = l_approver_id
1108: AND role_resource_type = 'RS_INDIVIDUAL'
1109: AND delete_flag = 'N'
1110: AND TRUNC(SYSDATE) BETWEEN TRUNC(res_rl_start_date)
1111: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1112: */

Line 1120: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1116: jtf_rs_roles_b rl
1117: WHERE rr.role_id = rl.role_id
1118: AND rl.role_type_code IN( 'MKTGAPPR','AMSAPPR')
1119: AND rl.role_code = 'AMS_DEFAULT_APPROVER'
1120: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1121: AND delete_flag = 'N'
1122: AND TRUNC(SYSDATE) BETWEEN TRUNC(rr.start_date_active)
1123: AND TRUNC(NVL(rr.end_date_active,SYSDATE));
1124:

Line 2348: FROM dual

2344: l_dummy := SYSDATE;
2345: LOOP
2346: SELECT 'x'
2347: INTO l_dummy1
2348: FROM dual
2349: WHERE (( SYSDATE - l_dummy )*(24*60)) < .01 ;
2350: END LOOP;
2351: EXCEPTION
2352: WHEN OTHERS THEN

Line 7666: AND rr.role_resource_type = 'RS_INDIVIDUAL'

7662: CURSOR c_is_requestor_def_appr IS
7663: SELECT rr.role_resource_id
7664: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7665: WHERE rr.role_id = rl.role_id
7666: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7667: AND rl.role_code = 'AMS_DEFAULT_APPROVER'
7668: AND rr.delete_flag = 'N'
7669: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
7670: AND rl.role_type_code IN ('AMSAPPR','MKTGAPPR')

Line 7677: AND rr.role_resource_type = 'RS_INDIVIDUAL'

7673: CURSOR c_is_requestor_appr_role IS
7674: SELECT rr.role_resource_id
7675: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7676: WHERE rr.role_id = rl.role_id
7677: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7678: AND rr.delete_flag = 'N'
7679: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
7680: AND rl.role_type_code IN ('MKTGAPPR', 'AMSAPPR')
7681: AND rr.role_id = l_obj_approver_id