DBA Data[Home] [Help]

APPS.PV_OPPORTUNITY_VHUK dependencies on AS_LEAD_LINES

Line 882: FROM as_lead_lines

878: AND ld.lead_id = pc_lead_id;
879:
880: CURSOR lc_get_opp_amt (pc_lead_id NUMBER) is
881: SELECT SUM(NVL(total_amount,0))
882: FROM as_lead_lines
883: WHERE lead_id = pc_lead_id;
884:
885: /* CURSOR lc_address (pc_party_relation_id number) is
886: SELECT address_id, resource_id