APPS.AMS_APPROVAL_UTIL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 58

  l_stmt := 'SELECT owner_user_id FROM '||l_table_name||' where '||l_pk_name||' = :b1';

Line: 62

	l_stmt := 'SELECT owner_id FROM '||l_table_name||' where '||l_pk_name||' = :b1';

Line: 119

    SELECT B.owner_user_id
    FROM ams_campaign_schedules_vl A, ams_campaigns_vl B
    WHERE B.campaign_id = A.campaign_id
    AND A.schedule_id = l_activity_id;

Line: 125

    SELECT B.owner_user_id
    FROM ams_event_offers_vl A, ams_event_headers_vl B
    WHERE B.event_header_id = A.event_header_id
    AND A.event_offer_id = l_activity_id;

Line: 131

    SELECT B.owner_user_id
    FROM ams_act_offers A, ams_campaigns_vl B
    WHERE B.campaign_id = A.act_offer_used_by_id
    AND A.arc_act_offer_used_by = 'CAMP'
    AND A.qp_list_header_id = l_activity_id;

Line: 163

SELECT owner
FROM ozf_funds_all_b
WHERE fund_id = l_budget_id;

Line: 170

SELECT owner
from ozf_funds_all_b
WHERE fund_id IN (SELECT budget_source_id
                    FROM ozf_act_budgets
		   WHERE activity_budget_id = l_activity_id);

Line: 177

SELECT f.owner
FROM ozf_funds_all_b f, ozf_act_budgets a
WHERE f.fund_id = a.budget_source_id
AND a.activity_budget_id = l_activity_id;

Line: 264

SELECT B.owner
FROM ozf_funds_all_b A, ozf_funds_all_b B
WHERE A.parent_fund_id = B.fund_id
AND B.fund_id = l_activity_id;

Line: 271

SELECT B.owner
FROM ozf_funds_all_b A, ozf_funds_all_b B
WHERE A.parent_fund_id = B.fund_id
AND B.fund_id IN (SELECT budget_source_id
                    FROM ozf_act_budgets
		    WHERE activity_budget_id = l_activity_id);