APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on JTF_RS_SALESREPS

Line 122: CURSOR get_org_and_srp_id(p_person_id jtf_rs_salesreps.person_id%TYPE)

118: x_new_start_date OUT NOCOPY Date,
119: x_new_end_date OUT NOCOPY Date
120: )
121: IS
122: CURSOR get_org_and_srp_id(p_person_id jtf_rs_salesreps.person_id%TYPE)
123: IS
124: SELECT rs.org_id, rs.salesrep_id, hou.name operating_unit
125: FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,
126: hr_operating_units hou

Line 125: FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,

121: IS
122: CURSOR get_org_and_srp_id(p_person_id jtf_rs_salesreps.person_id%TYPE)
123: IS
124: SELECT rs.org_id, rs.salesrep_id, hou.name operating_unit
125: FROM jtf_rs_salesreps rs, jtf_rs_resource_extns rre,
126: hr_operating_units hou
127: WHERE rre.source_id = p_person_id
128: AND rre.resource_id = rs.resource_id
129: AND rre.category = 'EMPLOYEE'

Line 145: CURSOR get_comm_and_pmt(p_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,

141: AND p_start_date <= end_date
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