APPS.AS_OPP_SALES_CREDIT_PVT dependencies on AS_ACCESSES

Line 201: from as_accesses

197: instead of 'X'.
198: */
199: cursor get_dup_sales_team(c_customer_id NUMBER,c_address_id NUMBER,c_lead_id NUMBER,c_salesforce_id NUMBER, c_sales_group_id NUMBER ) is
200: select team_leader_flag,last_update_date,access_id
201: from as_accesses
202: where customer_id = c_customer_id
203: --and nvl(address_id, -99) = nvl(c_address_id, -99)
204: and nvl(lead_id, -99) = nvl(c_lead_id, -99)
205: and salesforce_id = c_salesforce_id

Line 905: from as_accesses

901: instead of 'X'.
902: */
903: cursor get_dup_sales_team(c_customer_id NUMBER,c_address_id NUMBER,c_lead_id NUMBER,c_salesforce_id NUMBER, c_sales_group_id NUMBER ) is
904: select team_leader_flag,last_update_date,access_id
905: from as_accesses
906: where customer_id = c_customer_id
907: --and nvl(address_id, -99) = nvl(c_address_id, -99)
908: and nvl(lead_id, -99) = nvl(c_lead_id, -99)
909: and salesforce_id = c_salesforce_id

Line 914: from as_accesses

910: and nvl(sales_group_id, -99) = nvl(c_sales_group_id, -99);
911:
912: cursor get_dup_sales_partner(c_customer_id NUMBER,c_address_id NUMBER,c_lead_id NUMBER,c_salesforce_id NUMBER, c_sales_group_id NUMBER ) is
913: select 'X'
914: from as_accesses
915: where customer_id = c_customer_id
916: --and nvl(address_id, -99) = nvl(c_address_id, -99)
917: and nvl(lead_id, -99) = nvl(c_lead_id, -99)
918: and salesforce_id = c_salesforce_id;