APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on JTF_RS_REP_MANAGERS

Line 252: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a

248: into l_res_cnt
249: from
250: JTF_RS_RESOURCE_EXTNS
251: where source_id in ( select distinct b.person_id
252: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
253: where b.manager_person_id = a.source_id
254: and a.resource_id = p_group_by_value_coll);--100000937);
255:
256: if l_res_cnt <> 0 then

Line 261: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||

257: l_res_qry:= '(select distinct resource_id '||
258: 'from '||
259: 'JTF_RS_RESOURCE_EXTNS '||
260: 'where source_id in (select distinct b.person_id '||
261: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
262: 'where b.manager_person_id = a.source_id '||
263: 'and a.resource_id = '||p_group_by_value_coll;
264:
265: l_where:=l_where||' and ipd1.resource_id in '|| l_res_qry ;

Line 633: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a

629: into l_resr_cnt
630: from
631: JTF_RS_RESOURCE_EXTNS
632: where source_id in ( select distinct b.person_id
633: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
634: where b.manager_person_id = a.source_id
635: and a.resource_id = p_group_by_value_coll);--100000937);
636:
637: if l_resr_cnt <> 0 then

Line 642: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||

638: l_resr_qry:= '(select distinct resource_id '||
639: 'from '||
640: 'JTF_RS_RESOURCE_EXTNS '||
641: 'where source_id in (select distinct b.person_id '||
642: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
643: 'where b.manager_person_id = a.source_id '||
644: 'and a.resource_id = '||p_group_by_value_coll;
645:
646: l_where:=l_where||' and ipd1.resource_id in '|| l_resr_qry ;