APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_ACCESSES_ALL

Line 581: FROM as_accesses_all

577: CURSOR C_Sales_Owner_Check (X_Identity_Salesforce_Id NUMBER,
578: X_Opportunity_Id NUMBER,
579: X_Team_Leader_Flag VARCHAR2) IS
580: SELECT salesforce_id
581: FROM as_accesses_all
582: WHERE salesforce_id = X_Identity_Salesforce_Id
583: AND lead_id = X_Opportunity_Id
584: AND team_leader_flag = X_Team_Leader_Flag;
585:

Line 588: FROM as_accesses_all

584: AND team_leader_flag = X_Team_Leader_Flag;
585:
586: CURSOR C_Get_Sales_Owner (X_Opportunity_Id NUMBER) IS
587: SELECT salesforce_id
588: FROM as_accesses_all
589: WHERE lead_id = X_Opportunity_Id
590: AND team_leader_flag = 'Y';
591:
592: /*

Line 1615: FROM as_accesses_all

1611: CURSOR C_Sales_Owner_Check (X_Identity_Salesforce_Id NUMBER,
1612: X_Opportunity_Id NUMBER,
1613: X_Team_Leader_Flag VARCHAR2) IS
1614: SELECT salesforce_id
1615: FROM as_accesses_all
1616: WHERE salesforce_id = X_Identity_Salesforce_Id
1617: AND lead_id = X_Opportunity_Id
1618: AND team_leader_flag = X_Team_Leader_Flag;
1619:

Line 1622: FROM as_accesses_all

1618: AND team_leader_flag = X_Team_Leader_Flag;
1619:
1620: CURSOR C_Get_Sales_Owner (X_Opportunity_Id NUMBER) IS
1621: SELECT salesforce_id
1622: FROM as_accesses_all
1623: WHERE lead_id = X_Opportunity_Id
1624: AND team_leader_flag = 'Y';
1625:
1626:

Line 2436: FROM as_accesses_all

2432: partner_cont_party_id, created_by_tap_flag, prm_keep_flag
2433: -- ffang 062502, bug 2432561
2434: , owner_flag
2435: -- end ffang 062502
2436: FROM as_accesses_all
2437: WHERE sales_lead_id = c_sl_id;
2438: --Code added for Enhancement convert lead to opportunity - Attachment
2439: --Enhancement related Bug#3913225 @ @ Callling the procedure Copy_Attachments--changes for ASN.B--Start--
2440: CURSOR C_Attachment_Exists(X_Sales_Lead_Id VARCHAR2) IS