APPS.AS_DECISION_FACTOR_PVT dependencies on AS_LEAD_LINES

Line 40: FROM as_lead_lines_all

36:
37: IS
38: CURSOR G_lead_id(p_lead_line_id NUMBER) IS
39: SELECT lead_id
40: FROM as_lead_lines_all
41: WHERE lead_line_id = p_lead_line_id;
42:
43: l_api_name CONSTANT VARCHAR2(30) := 'Create_decision_factor';
44: l_api_version_number CONSTANT NUMBER := 2.0;

Line 383: FROM as_lead_lines_all

379:
380: IS
381: CURSOR G_lead_id(p_lead_line_id NUMBER) IS
382: SELECT lead_id
383: FROM as_lead_lines_all
384: WHERE lead_line_id = p_lead_line_id;
385:
386: l_Decision_Factor_Rec AS_OPPORTUNITY_PUB.Decision_Factor_Rec_Type;
387: l_Decision_Factor_Tbl AS_OPPORTUNITY_PUB.Decision_Factor_Tbl_Type;

Line 695: FROM as_lead_lines_all

691: )
692: IS
693: CURSOR G_lead_id(p_lead_line_id NUMBER) IS
694: SELECT lead_id
695: FROM as_lead_lines_all
696: WHERE lead_line_id = p_lead_line_id;
697: l_api_name CONSTANT VARCHAR2(30) := 'Delete_decision_factor';
698: l_api_version_number CONSTANT NUMBER := 2.0;
699: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

Line 1303: FROM AS_LEAD_LINES

1299: IS
1300:
1301: CURSOR C_Lead_Line_Id_Exists (c_Lead_Line_Id NUMBER) IS
1302: SELECT 'X'
1303: FROM AS_LEAD_LINES
1304: WHERE LEAD_LINE_ID = c_Lead_Line_Id;
1305:
1306: l_val VARCHAR2(1);
1307: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);