APPS.HR_PPVOL dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 192: from pay_org_pay_method_usages_f opmu

188: cursor csr_payroll_opmu is
189: select opmu.effective_start_date,
190: opmu.effective_end_date,
191: org_pay_method_usage_id
192: from pay_org_pay_method_usages_f opmu
193: where opmu.payroll_id = payroll
194: and opmu.org_payment_method_id = payment_method
195: and opmu.effective_start_date <= end_date
196: and opmu.effective_end_date >= start_date

Line 215: from pay_org_pay_method_usages_f

211: --correctly.
212: /*begin
213: select org_pay_method_usage_id
214: into pmu_id
215: from pay_org_pay_method_usages_f
216: where payroll_id = payroll
217: and org_payment_method_id = payment_method
218: and effective_start_date < end_date
219: and effective_end_date > start_date;

Line 235: insert into pay_org_pay_method_usages_f

231: select pay_org_pay_method_usages_s.nextval
232: into pmu_id
233: from sys.dual;
234: --
235: insert into pay_org_pay_method_usages_f
236: (org_pay_method_usage_id,
237: effective_start_date,
238: effective_end_date,
239: org_payment_method_id,

Line 273: update pay_org_pay_method_usages_f opmu

269: -- adjust opmu |--|. .
270: -- insert new opmu |----------------------------| (see below)
271: elsif v_opmu_rec.effective_start_date < start_date then
272: --
273: update pay_org_pay_method_usages_f opmu
274: set opmu.effective_end_date = start_date - 1
275: where current of csr_payroll_opmu;
276: --
277: -- opmu overlaps with end of required opmu so need to shorten it ie.

Line 285: update pay_org_pay_method_usages_f opmu

281: -- adjust opmu . .|----|
282: -- insert new opmu |----------------------------| (see below)
283: elsif v_opmu_rec.effective_end_date > end_date then
284: --
285: update pay_org_pay_method_usages_f opmu
286: set opmu.effective_start_date = end_date + 1
287: where current of csr_payroll_opmu;
288: --
289: -- opmu overlaps within required opmu so need to remove it ie.

Line 297: delete from pay_org_pay_method_usages_f

293: -- remove opmu . .
294: -- insert new opmu |----------------------------| (see below)
295: else
296: --
297: delete from pay_org_pay_method_usages_f
298: where current of csr_payroll_opmu;
299: --
300: end if;
301:

Line 309: insert into pay_org_pay_method_usages_f

305: --
306: select pay_org_pay_method_usages_s.nextval into pmu_id from sys.dual;
307: -- Create opmu to represent the default payment method selected for the
308: -- payroll.
309: insert into pay_org_pay_method_usages_f
310: (org_pay_method_usage_id,
311: effective_start_date,
312: effective_end_date,
313: payroll_id,