APPS.GHR_PAY_CAPS dependencies on GHR_PERF_CERT

Line 173: FROM ghr_perf_cert

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

Line 188: FROM ghr_perf_cert

184: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
185: p_business_group_id number)
186: IS
187: SELECT cert_group
188: FROM ghr_perf_cert
189: WHERE cert_agency IS NULL
190: AND cert_agency_sub_code = p_agency_sub_code
191: AND cert_organization IS NULL
192: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )

Line 204: FROM ghr_perf_cert

200: p_pay_plan ghr_pay_plans.pay_plan%TYPE,
201: p_business_group_id number)
202: IS
203: SELECT cert_group
204: FROM ghr_perf_cert
205: WHERE cert_agency IS NULL
206: AND cert_agency_sub_code IS NULL
207: AND cert_organization = p_org_id
208: AND p_eff_date BETWEEN cert_start_date AND nvl(cert_end_date,to_date('31/12/4712','DD/MM/YYYY') )

Line 223: l_cert_group ghr_perf_cert.cert_group%type;

219: WHERE ppl.pay_plan = p_pay_plan;
220: --
221: ll_pay_plan ghr_pay_plans.pay_plan%TYPE;
222: l_from_Other_pay ghr_pa_requests.to_other_pay_amount%TYPE;
223: l_cert_group ghr_perf_cert.cert_group%type;
224: l_business_group_id per_positions.organization_id%TYPE;
225: --
226: -- PERFORMANCE CERTIFICATION CURSOR DECLARATIONS END HERE
227: --