APPS.PAY_PAYROLLS_F_PKG dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 691: from pay_org_pay_method_usages_f opmu

687: --
688: cursor csr_payroll_opmu is
689: select opmu.effective_start_date,
690: opmu.effective_end_date
691: from pay_org_pay_method_usages_f opmu
692: where opmu.payroll_id = p_payroll_id
693: and opmu.org_payment_method_id = p_default_payment_method_id
694: and opmu.effective_start_date <= p_validation_end_date
695: and opmu.effective_end_date >= p_validation_start_date

Line 727: update pay_org_pay_method_usages_f opmu

723: -- adjust opmu |--|. .
724: -- insert new opmu |----------------------------| (see below)
725: elsif v_opmu_rec.effective_start_date < p_validation_start_date then
726: --
727: update pay_org_pay_method_usages_f opmu
728: set opmu.effective_end_date = p_validation_start_date - 1
729: where current of csr_payroll_opmu;
730: --
731: -- opmu overlaps with end of required opmu so need to shorten it ie.

Line 739: update pay_org_pay_method_usages_f opmu

735: -- adjust opmu . .|----|
736: -- insert new opmu |----------------------------| (see below)
737: elsif v_opmu_rec.effective_end_date > p_validation_end_date then
738: --
739: update pay_org_pay_method_usages_f opmu
740: set opmu.effective_start_date = p_validation_end_date + 1
741: where current of csr_payroll_opmu;
742: --
743: -- opmu overlaps within required opmu so need to remove it ie.

Line 751: delete from pay_org_pay_method_usages_f

747: -- remove opmu . .
748: -- insert new opmu |----------------------------| (see below)
749: else
750: --
751: delete from pay_org_pay_method_usages_f
752: where current of csr_payroll_opmu;
753: --
754: end if;
755:

Line 762: insert into pay_org_pay_method_usages_f

758: if v_insert_record then
759: --
760: -- Create opmu to represent the default payment method selected for the
761: -- payroll.
762: insert into pay_org_pay_method_usages_f
763: (org_pay_method_usage_id,
764: effective_start_date,
765: effective_end_date,
766: payroll_id,

Line 1361: delete from pay_org_pay_method_usages_f opu

1357: --
1358: delete from per_time_periods tpe
1359: where tpe.payroll_id = p_payroll_id;
1360: --
1361: delete from pay_org_pay_method_usages_f opu
1362: where opu.payroll_id = p_payroll_id;
1363: --
1364: delete from pay_payroll_gl_flex_maps gfm
1365: where gfm.payroll_id = p_payroll_id;

Line 1412: delete from pay_org_pay_method_usages_f opu

1408: --
1409: -- All opmu's for a payroll must exist within the lifetime of the payroll
1410: -- so any opmus that exist outisde the new dates will be removed /
1411: -- shortened.
1412: delete from pay_org_pay_method_usages_f opu
1413: where opu.payroll_id = p_payroll_id
1414: and opu.effective_start_date >= p_validation_start_date;
1415: --
1416: update pay_org_pay_method_usages_f opu

Line 1416: update pay_org_pay_method_usages_f opu

1412: delete from pay_org_pay_method_usages_f opu
1413: where opu.payroll_id = p_payroll_id
1414: and opu.effective_start_date >= p_validation_start_date;
1415: --
1416: update pay_org_pay_method_usages_f opu
1417: set opu.effective_end_date = p_validation_start_date - 1
1418: where opu.payroll_id = p_payroll_id
1419: and opu.effective_end_date >= p_validation_start_date;
1420: --