APPS.HR_DELETE dependencies on PAY_PAYROLLS_F

Line 1634: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)

1630: --
1631: l_exists varchar2(1);
1632: --
1633: cursor csr_get_bg_payrolls
1634: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1635: is
1636: SELECT null
1637: FROM pay_payrolls_f
1638: WHERE business_group_id = c_business_group_id;

Line 1637: FROM pay_payrolls_f

1633: cursor csr_get_bg_payrolls
1634: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1635: is
1636: SELECT null
1637: FROM pay_payrolls_f
1638: WHERE business_group_id = c_business_group_id;
1639: --
1640: begin
1641: hr_utility.set_location('Entering: '||l_proc,10);

Line 1652: FROM pay_payrolls_f pp

1648: --
1649: DELETE FROM pay_org_pay_method_usages_f pmu
1650: WHERE
1651: EXISTS ( SELECT ''
1652: FROM pay_payrolls_f pp
1653: WHERE pp.payroll_id = pmu.payroll_id
1654: AND pp.business_group_id = p_business_group_id);
1655: hr_utility.set_location(l_proc,30);
1656: --

Line 1672: FROM pay_payrolls_f pp

1668: --
1669: --
1670: DELETE FROM PER_TIME_PERIODS tim
1671: WHERE EXISTS ( SELECT ''
1672: FROM pay_payrolls_f pp
1673: WHERE pp.payroll_id = tim.payroll_id
1674: AND pp.business_group_id = p_business_group_id);
1675: hr_utility.set_location(l_proc,70);
1676: --

Line 1679: FROM pay_payrolls_f pp

1675: hr_utility.set_location(l_proc,70);
1676: --
1677: DELETE FROM pay_payroll_gl_flex_maps glf
1678: WHERE EXISTS ( SELECT ''
1679: FROM pay_payrolls_f pp
1680: WHERE pp.payroll_id = glf.payroll_id
1681: AND pp.business_group_id = p_business_group_id);
1682: hr_utility.set_location(l_proc,80);
1683: --

Line 1684: DELETE FROM pay_payrolls_f pay

1680: WHERE pp.payroll_id = glf.payroll_id
1681: AND pp.business_group_id = p_business_group_id);
1682: hr_utility.set_location(l_proc,80);
1683: --
1684: DELETE FROM pay_payrolls_f pay
1685: WHERE pay.business_group_id = p_business_group_id;
1686: hr_utility.set_location(l_proc,90);
1687: --
1688: end if;

Line 1704: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)

1700: --
1701: l_exists varchar2(1);
1702: --
1703: cursor csr_get_def_bals
1704: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1705: is
1706: SELECT null
1707: FROM PAY_DEFINED_BALANCES
1708: WHERE business_group_id = c_business_group_id;

Line 1711: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)

1707: FROM PAY_DEFINED_BALANCES
1708: WHERE business_group_id = c_business_group_id;
1709: --
1710: cursor csr_get_bal_types
1711: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1712: is
1713: select balance_type_id
1714: from pay_balance_types
1715: where business_group_id = c_business_group_id;

Line 1791: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)

1787: --
1788: l_exists varchar2(1);
1789: --
1790: cursor csr_get_mess_lines
1791: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1792: is
1793: SELECT null
1794: FROM PAY_MESSAGE_LINES
1795: WHERE source_id = c_business_group_id

Line 2227: FROM pay_payrolls_f pay

2223: hr_utility.set_location(l_proc,30);
2224: --
2225: DELETE FROM pay_payroll_list ppl
2226: WHERE EXISTS ( SELECT ''
2227: FROM pay_payrolls_f pay
2228: WHERE pay.payroll_id = ppl.payroll_id
2229: AND pay.business_group_id = p_business_group_id);
2230: hr_utility.set_location(l_proc,40);
2231: --