APPS.PV_REFERRAL_GENERAL_PUB dependencies on AS_ACCESSES_ALL

Line 933: FROM as_accesses_all

929: -- Check if a resource is already on the sales team.
930: -- ------------------------------------------------------------------
931: CURSOR c_lead_in_sales_team (pc_sales_lead_id NUMBER, pc_resource_id NUMBER) IS
932: SELECT COUNT(*) st_count
933: FROM as_accesses_all
934: WHERE sales_lead_id = pc_sales_lead_id AND
935: salesforce_id = pc_resource_id;
936:
937: CURSOR c_oppty_in_sales_team (pc_lead_id NUMBER, pc_resource_id NUMBER) IS

Line 939: FROM as_accesses_all

935: salesforce_id = pc_resource_id;
936:
937: CURSOR c_oppty_in_sales_team (pc_lead_id NUMBER, pc_resource_id NUMBER) IS
938: SELECT COUNT(*) st_count
939: FROM as_accesses_all
940: WHERE lead_id = pc_lead_id AND
941: salesforce_id = pc_resource_id;
942:
943:

Line 1518: -- sales team (as_accesses_all).

1514:
1515: AML_SALES_LEADS_V2_PUB.Create_SALES_LEAD (
1516: p_api_version_number => 2.0,
1517: p_Check_Access_Flag => 'N', -- does not require the invoker to be on the
1518: -- sales team (as_accesses_all).
1519: p_Admin_Flag => 'N',
1520: p_admin_group_id => null,
1521: p_identity_salesforce_id => l_invoker_resource_id,
1522: p_salesgroup_id => l_invoker_salesgroup_id,

Line 1847: x_access_id => l_access_id); -- primary key of the as_accesses_all.

1843: p_sales_team_rec => l_sales_team_rec,
1844: x_return_status => x_return_status,
1845: x_msg_count => x_msg_count,
1846: x_msg_data => x_msg_data,
1847: x_access_id => l_access_id); -- primary key of the as_accesses_all.
1848: -- we don't need it.
1849:
1850: Debug('Return Status: ' || x_return_status);
1851: