DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_OBJECT_GROUPS

Line 278: from pay_object_groups.

274: delete_person_direct
275: 115.34 23-JUN-04 adhunter added revision comment
276: 115.35 26-SEP-04 nbristow Changed code so that it can be run on the
277: test harness DB. Also not deleting
278: from pay_object_groups.
279: 115.36 06-MAR-05 nbristow Now deleting the time definitions.
280: */
281: --
282: -- Package variables

Line 920: DELETE FROM pay_object_groups pog

916: open csr_get_asg (p_business_group_id);
917: fetch csr_get_asg into l_exists;
918: if csr_get_asg%found then
919: --
920: DELETE FROM pay_object_groups pog
921: WHERE
922: SOURCE_TYPE = 'PAF'
923: AND
924: EXISTS

Line 1344: DELETE FROM pay_object_groups pog

1340: open csr_get_person(p_business_group_id);
1341: fetch csr_get_person into l_exists;
1342: if csr_get_person%found then
1343: --
1344: DELETE FROM pay_object_groups pog
1345: WHERE
1346: SOURCE_TYPE = 'PPF'
1347: AND
1348: EXISTS (SELECT ''