APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_PAYRUNS

Line 1178: select pay_period_id into x_period_id from cn_payruns where payrun_id=p_payrun_id;

1174: AND srp.credit_type_id = -1000
1175: AND w.quota_id <> -1000
1176: ORDER BY assign.start_date;
1177: begin
1178: select pay_period_id into x_period_id from cn_payruns where payrun_id=p_payrun_id;
1179: for p in get_plans(x_period_id,
1180: p_payrun_id,
1181: p_salesrep_id,
1182: p_org_id) loop