DBA Data[Home] [Help]

APPS.CN_TSR_PVT dependencies on CN_SRP_HR_DATA

Line 82: cn_srp_hr_data hr1

78: hr1.emp_num tsr_emp_no,
79: hr1.name tsr_name,
80: hr1.srp_id tsr_srp_id
81: FROM
82: cn_srp_hr_data hr1
83: WHERE
84: NOT EXISTS (
85: SELECT 1
86: from jtf_rs_groups_vl jg,

Line 121: cn_srp_hr_data hr1

117: hr1.emp_num tsr_emp_no,
118: hr1.name tsr_name,
119: hr1.srp_id tsr_srp_id
120: FROM
121: cn_srp_hr_data hr1
122: WHERE
123: EXISTS (
124: SELECT 1
125: from jtf_rs_groups_vl jg,

Line 192: cn_srp_hr_data

188: emp_num mgr_emp_no,
189: name mgr_name,
190: srp_id tsr_mgr_id
191: FROM
192: cn_srp_hr_data
193: WHERE srp_id = P_MGR_SRP_ID;
194:
195:
196: