APPS.AMS_APPROVAL_PVT dependencies on DUAL

Line 1112: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1108: CURSOR c_role_info IS
1109: SELECT rr.role_resource_id, rl.role_name
1110: FROM jtf_rs_role_relations rr, jtf_rs_roles_vl rl
1111: WHERE rr.role_id = rl.role_id
1112: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1113: AND rr.delete_flag = 'N'
1114: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
1115: AND rl.role_type_code in ( 'MKTGAPPR', 'AMSAPPR')
1116: AND rl.role_id = l_approver_id;

Line 1124: AND role_resource_type = 'RS_INDIVIDUAL'

1120: , role_name
1121: FROM jtf_rs_defresroles_vl
1122: WHERE role_type_code IN ('MKTGAPPR','AMSAPPR')
1123: AND role_id = l_approver_id
1124: AND role_resource_type = 'RS_INDIVIDUAL'
1125: AND delete_flag = 'N'
1126: AND TRUNC(SYSDATE) BETWEEN TRUNC(res_rl_start_date)
1127: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1128: */

Line 1133: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1129: CURSOR c_role_info_count IS
1130: SELECT COUNT(1)
1131: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1132: WHERE rr.role_id = rl.role_id
1133: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1134: AND rr.delete_flag = 'N'
1135: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
1136: AND rl.role_type_code in ( 'MKTGAPPR', 'AMSAPPR')
1137: AND rl.role_id = l_approver_id;

Line 1144: AND role_resource_type = 'RS_INDIVIDUAL'

1140: SELECT COUNT(1)
1141: FROM jtf_rs_defresroles_vl
1142: WHERE role_type_code IN ('MKTGAPPR','AMSAPPR')
1143: AND role_id = l_approver_id
1144: AND role_resource_type = 'RS_INDIVIDUAL'
1145: AND delete_flag = 'N'
1146: AND TRUNC(SYSDATE) BETWEEN TRUNC(res_rl_start_date)
1147: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1148: */

Line 1156: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1152: jtf_rs_roles_b rl
1153: WHERE rr.role_id = rl.role_id
1154: AND rl.role_type_code IN( 'MKTGAPPR','AMSAPPR')
1155: AND rl.role_code = 'AMS_DEFAULT_APPROVER'
1156: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1157: AND delete_flag = 'N'
1158: AND TRUNC(SYSDATE) BETWEEN TRUNC(rr.start_date_active)
1159: AND TRUNC(NVL(rr.end_date_active,SYSDATE));
1160:

Line 2384: FROM dual

2380: l_dummy := SYSDATE;
2381: LOOP
2382: SELECT 'x'
2383: INTO l_dummy1
2384: FROM dual
2385: WHERE (( SYSDATE - l_dummy )*(24*60)) < .01 ;
2386: END LOOP;
2387: EXCEPTION
2388: WHEN OTHERS THEN

Line 7757: AND rr.role_resource_type = 'RS_INDIVIDUAL'

7753: CURSOR c_is_requestor_def_appr IS
7754: SELECT rr.role_resource_id
7755: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7756: WHERE rr.role_id = rl.role_id
7757: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7758: AND rl.role_code = 'AMS_DEFAULT_APPROVER'
7759: AND rr.delete_flag = 'N'
7760: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
7761: AND rl.role_type_code IN ('AMSAPPR','MKTGAPPR')

Line 7768: AND rr.role_resource_type = 'RS_INDIVIDUAL'

7764: CURSOR c_is_requestor_appr_role IS
7765: SELECT rr.role_resource_id
7766: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
7767: WHERE rr.role_id = rl.role_id
7768: AND rr.role_resource_type = 'RS_INDIVIDUAL'
7769: AND rr.delete_flag = 'N'
7770: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
7771: AND rl.role_type_code IN ('MKTGAPPR', 'AMSAPPR')
7772: AND rr.role_id = l_obj_approver_id