APPS.PV_MATCH_V3_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 1213: FROM fnd_user a, jtf_rs_resource_extns b

1209: -- ------------------------------------------------------------------------
1210: IF (p_resource_id IS NULL) THEN
1211: SELECT resource_id
1212: INTO l_resource_id
1213: FROM fnd_user a, jtf_rs_resource_extns b
1214: WHERE a.user_id = b.user_id AND
1215: a.user_name = p_user_name;
1216: ELSE
1217: l_resource_id := p_resource_id;

Line 3518: FROM jtf_rs_resource_extns jtfre

3514:
3515: CURSOR lc_user_type
3516: IS
3517: SELECT jtfre.category
3518: FROM jtf_rs_resource_extns jtfre
3519: WHERE jtfre.user_id = FND_GLOBAL.user_id
3520: AND start_date_active <= sysdate
3521: AND (end_date_active IS NULL OR end_date_active > sysdate);
3522: