DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on FND_GLOBAL

Line 3505: AND user_id = FND_GLOBAL.user_id;

3501: WHERE lead_assignment_id = pc_lead_assign_id
3502: AND wf_item_type = 'PVASGNMT'
3503: AND wf_item_key = pc_wf_item_key
3504: --AND notification_type = 'MATCHED_TO'
3505: AND user_id = FND_GLOBAL.user_id;
3506:
3507: CURSOR lc_routing_status (pc_wf_item_key VARCHAR2)
3508: IS
3509: SELECT routing_status

Line 3519: WHERE jtfre.user_id = FND_GLOBAL.user_id

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:
3523: