APPS.HR_DELETE dependencies on PER_PAY_PROPOSALS

Line 125: per_pay_proposals for a business group.

121: ben_benefit_contributions_f.
122: 70.33 22-JAN-96 mhoyes Added delete statements to
123: delete_assign_detail which delete from
124: per_pay_proposal_components and
125: per_pay_proposals for a business group.
126: 70.34 19-MAR-95 dsaxby Now call py_rollback_pkg version of
127: rollback_payroll_action.
128: 70.35 28-JUN-96 mhoyes a Added delete statement to
129: delete_bg_misc to delete

Line 139: statement for PER_PAY_PROPOSALS to

135: the referential integrity error
136: when RATE_ID is set for a pay basis.
137: c Moved the delete statement for
138: PER_EVENTS to after the delete
139: statement for PER_PAY_PROPOSALS to
140: avoid the referential integrity error
141: when EVENT_ID is set for a pay proposal.
142: 70.36 31-JUL-96 Tmathers a Made delete statment a dynamic sql
143: 70.37 28-AUG-96 mhoyes a Created new procedure

Line 770: PER_PAY_PROPOSALS.business_group_id%TYPE)

766: WHERE business_group_id = c_business_group_id);
767: --
768: cursor csr_get_pyp
769: (c_business_group_id
770: PER_PAY_PROPOSALS.business_group_id%TYPE)
771: is
772: SELECT null
773: FROM sys.dual
774: WHERE exists(select null

Line 775: FROM PER_PAY_PROPOSALS

771: is
772: SELECT null
773: FROM sys.dual
774: WHERE exists(select null
775: FROM PER_PAY_PROPOSALS
776: WHERE business_group_id = c_business_group_id);
777: --
778: cursor csr_get_crp
779: (c_business_group_id

Line 853: delete from per_pay_proposals

849: delete from per_pay_proposal_components ppc
850: where ppc.business_group_id = p_business_group_id;
851: hr_utility.set_location(l_proc, 70);
852: --
853: delete from per_pay_proposals
854: where business_group_id = p_business_group_id;
855: hr_utility.set_location(l_proc, 80);
856: --
857: end if;