APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on CN_PERIOD_STATUSES_ALL

Line 132: CURSOR get_period_ids(p_start_date cn_period_statuses_all.start_date%TYPE,

128: AND rre.resource_id = rs.resource_id
129: AND rre.category = 'EMPLOYEE'
130: AND rs.org_id = hou.organization_id;
131:
132: CURSOR get_period_ids(p_start_date cn_period_statuses_all.start_date%TYPE,
133: p_end_date cn_period_statuses_all.end_date%TYPE,
134: p_org_id cn_period_statuses_all.org_id%TYPE)
135: IS
136: SELECT min(period_id) start_period_id, max(period_id) end_period_id,

Line 133: p_end_date cn_period_statuses_all.end_date%TYPE,

129: AND rre.category = 'EMPLOYEE'
130: AND rs.org_id = hou.organization_id;
131:
132: CURSOR get_period_ids(p_start_date cn_period_statuses_all.start_date%TYPE,
133: p_end_date cn_period_statuses_all.end_date%TYPE,
134: p_org_id cn_period_statuses_all.org_id%TYPE)
135: IS
136: SELECT min(period_id) start_period_id, max(period_id) end_period_id,
137: min(start_date) new_start_date, max(end_date) new_end_date,

Line 134: p_org_id cn_period_statuses_all.org_id%TYPE)

130: AND rs.org_id = hou.organization_id;
131:
132: CURSOR get_period_ids(p_start_date cn_period_statuses_all.start_date%TYPE,
133: p_end_date cn_period_statuses_all.end_date%TYPE,
134: p_org_id cn_period_statuses_all.org_id%TYPE)
135: IS
136: SELECT min(period_id) start_period_id, max(period_id) end_period_id,
137: min(start_date) new_start_date, max(end_date) new_end_date,
138: (max(end_date) - min(start_date) + 1) total_days

Line 139: FROM cn_period_statuses_all

135: IS
136: SELECT min(period_id) start_period_id, max(period_id) end_period_id,
137: min(start_date) new_start_date, max(end_date) new_end_date,
138: (max(end_date) - min(start_date) + 1) total_days
139: FROM cn_period_statuses_all
140: WHERE start_date <= p_end_date
141: AND p_start_date <= end_date
142: AND org_id = p_org_id
143: ORDER BY period_id;

Line 146: p_start_period_id cn_period_statuses_all.period_id%TYPE,

142: AND org_id = p_org_id
143: ORDER BY period_id;
144:
145: CURSOR get_comm_and_pmt(p_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,
146: p_start_period_id cn_period_statuses_all.period_id%TYPE,
147: p_end_period_id cn_period_statuses_all.period_id%TYPE,
148: p_org_id cn_srp_periods_all.org_id%TYPE)
149: IS
150: SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,

Line 147: p_end_period_id cn_period_statuses_all.period_id%TYPE,

143: ORDER BY period_id;
144:
145: CURSOR get_comm_and_pmt(p_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,
146: p_start_period_id cn_period_statuses_all.period_id%TYPE,
147: p_end_period_id cn_period_statuses_all.period_id%TYPE,
148: p_org_id cn_srp_periods_all.org_id%TYPE)
149: IS
150: SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
151: NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt