DBA Data[Home] [Help]

APPS.AMS_APPROVERS_PVT dependencies on DUAL

Line 145: FROM dual;

141: l_row_id VARCHAR2(40);
142:
143: CURSOR c_seq IS
144: SELECT ams_approvers_s.NEXTVAL
145: FROM dual;
146:
147: CURSOR c_id_exists (x_id IN NUMBER) IS
148: SELECT 1 FROM dual
149: WHERE EXISTS (SELECT 1 FROM ams_approvers

Line 148: SELECT 1 FROM dual

144: SELECT ams_approvers_s.NEXTVAL
145: FROM dual;
146:
147: CURSOR c_id_exists (x_id IN NUMBER) IS
148: SELECT 1 FROM dual
149: WHERE EXISTS (SELECT 1 FROM ams_approvers
150: WHERE approver_id = x_id);
151: BEGIN
152: --------------------- initialize -----------------------

Line 1220: SELECT 1 FROM dual

1216: x_return_status OUT NOCOPY VARCHAR2
1217: )IS
1218: l_dummy NUMBER;
1219: CURSOR c_appr_seq_exists(seq_num_in IN NUMBER, id_in IN NUMBER) IS
1220: SELECT 1 FROM dual
1221: WHERE EXISTS (SELECT 1 FROM ams_approvers
1222: WHERE approver_seq = seq_num_in
1223: AND ams_approval_detail_id = id_in
1224: AND active_flag = 'Y'

Line 1282: SELECT 1 FROM dual

1278: x_return_status OUT NOCOPY VARCHAR2
1279: )IS
1280: l_dummy NUMBER;
1281: CURSOR c_uappr_id_exists(id_in IN NUMBER) IS
1282: SELECT 1 FROM dual
1283: WHERE EXISTS (SELECT 1 FROM ams_jtf_rs_emp_v
1284: WHERE RESOURCE_ID = id_in);
1285: CURSOR c_rappr_id_exists(id_in IN NUMBER) IS
1286: SELECT 1 FROM dual

Line 1286: SELECT 1 FROM dual

1282: SELECT 1 FROM dual
1283: WHERE EXISTS (SELECT 1 FROM ams_jtf_rs_emp_v
1284: WHERE RESOURCE_ID = id_in);
1285: CURSOR c_rappr_id_exists(id_in IN NUMBER) IS
1286: SELECT 1 FROM dual
1287: WHERE EXISTS ( SELECT 1
1288: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1289: WHERE rr.role_id = rl.role_id
1290: AND rr.role_resource_type = 'RS_INDIVIDUAL'

Line 1290: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1286: SELECT 1 FROM dual
1287: WHERE EXISTS ( SELECT 1
1288: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1289: WHERE rr.role_id = rl.role_id
1290: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1291: AND rr.delete_flag = 'N'
1292: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
1293: AND rl.role_type_code in ( 'MKTGAPPR', 'AMSAPPR')
1294: AND rr.role_id = id_in);

Line 1304: AND rr.role_resource_type = 'RS_INDIVIDUAL'

1300: CURSOR c_multi_appr_exists(id_in IN NUMBER) IS
1301: SELECT COUNT(1)
1302: FROM jtf_rs_role_relations rr, jtf_rs_roles_b rl
1303: WHERE rr.role_id = rl.role_id
1304: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1305: AND rr.delete_flag = 'N'
1306: AND SYSDATE BETWEEN rr.start_date_active and nvl(rr.end_date_active, SYSDATE)
1307: AND rl.role_type_code in ( 'MKTGAPPR', 'AMSAPPR')
1308: AND rr.role_id = id_in;

Line 1315: AND role_resource_type = 'RS_INDIVIDUAL'

1311: /*
1312: FROM jtf_rs_defresroles_vl
1313: WHERE role_type_code IN ('MKTGAPPR','AMSAPPR')
1314: AND role_id = id_in
1315: AND role_resource_type = 'RS_INDIVIDUAL'
1316: AND delete_flag = 'N'
1317: AND TRUNC(SYSDATE) BETWEEN TRUNC(res_rl_start_date)
1318: AND TRUNC(NVL(res_rl_end_date,SYSDATE));
1319: */