DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA dependencies on CN_SRP_PERIODS

Line 106: from cn_srp_periods p, cn_srp_plan_assigns spa

102: (nvl(balance28_bbd,0) - nvl(balance28_bbc,0))),0) begin_balance,
103: nvl(sum((nvl(balance2_dtd, 0) - nvl(balance2_ctd, 0)) +
104: (nvl(balance10_dtd,0) - nvl(balance10_ctd,0))),0) earnminuspay,
105: nvl(sum((nvl(balance28_dtd,0) - nvl(balance28_ctd,0))),0) draw
106: from cn_srp_periods p, cn_srp_plan_assigns spa
107: where spa.srp_plan_assign_id = l_srp_plan_assign_id
108: and p.salesrep_id = spa.salesrep_id
109: and p.credit_type_id = p_credit_type_id
110: and p.role_id = spa.role_id