DBA Data[Home] [Help]

APPS.PAY_OPM_BUS dependencies on PAY_PRE_PAYMENTS

Line 1355: from pay_pre_payments ppm

1351: l_dummy number;
1352: --
1353: cursor csr_pre_payment_exists is
1354: select null
1355: from pay_pre_payments ppm
1356: , pay_assignment_actions paa
1357: , pay_payroll_actions ppa
1358: where ppm.org_payment_method_id = p_org_payment_method_id
1359: and ppm.assignment_action_id = paa.assignment_action_id

Line 1677: -- PAY_PRE_PAYMENTS,

1673: --
1674: -- Check if there is no child row exists in
1675: -- PAY_ORG_PAYMENT_METHODS_TL,
1676: -- PAY_ORG_METHOD_USAGES_F,
1677: -- PAY_PRE_PAYMENTS,
1678: -- PAY_RUN_TYPE_ORG_METHODS,
1679: -- PAY_PAYROLL_ACTIONS,
1680: -- PAY_ALL_PAYROLLS_F,
1681: -- and

Line 1722: from pay_pre_payments ppt,

1718: l_exists varchar2(1);
1719: --
1720: cursor csr_pre_payment_exists is
1721: select null
1722: from pay_pre_payments ppt,
1723: pay_assignment_actions paa,
1724: pay_payroll_actions ppa
1725: where ppt.org_payment_method_id = p_org_payment_method_id
1726: and ppt.assignment_action_id = paa.assignment_action_id

Line 1793: fnd_message.set_token('TABLE_NAME', 'PAY_PRE_PAYMENTS');

1789: --
1790: close csr_pre_payment_exists;
1791: --
1792: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1793: fnd_message.set_token('TABLE_NAME', 'PAY_PRE_PAYMENTS');
1794: fnd_message.raise_error;
1795: --
1796: End If;
1797: --