APPS.GHR_PAY_CAPS dependencies on GHR_PERF_CERT

Line 171: FROM ghr_perf_cert

167: p_agency_code ghr_pa_Requests.agency_code%TYPE,
168: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
169: IS
170: SELECT distinct cert_group
171: FROM ghr_perf_cert
172: WHERE cert_agency = substr(p_agency_code,1,2)
173: AND cert_agency_sub_code IS NULL
174: AND cert_organization IS NULL
175: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )

Line 183: FROM ghr_perf_cert

179: p_agency_sub_code ghr_pa_Requests.agency_code%TYPE,
180: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
181: IS
182: SELECT cert_group
183: FROM ghr_perf_cert
184: WHERE cert_agency IS NULL
185: AND cert_agency_sub_code = p_agency_sub_code
186: AND cert_organization IS NULL
187: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )

Line 196: FROM ghr_perf_cert

192: p_org_id per_positions.organization_id%TYPE,
193: p_pay_plan ghr_pay_plans.pay_plan%TYPE)
194: IS
195: SELECT cert_group
196: FROM ghr_perf_cert
197: WHERE cert_agency IS NULL
198: AND cert_agency_sub_code IS NULL
199: AND cert_organization = p_org_id
200: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )

Line 212: l_cert_group ghr_perf_cert.cert_group%type;

208: WHERE ppl.pay_plan = p_pay_plan;
209: --
210: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
211: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;
212: l_cert_group ghr_perf_cert.cert_group%type;
213: l_business_group_id per_positions.organization_id%TYPE;
214: --
215: -- PERFORMANCE CERTIFICATION CURSOR DECLARATIONS END HERE
216: --