APPS.PAY_OPM_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 1357: , pay_payroll_actions ppa

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
1360: and paa.payroll_action_id = ppa.payroll_action_id
1361: and ppa.action_type in ('P', 'U')

Line 1679: -- PAY_PAYROLL_ACTIONS,

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
1682: -- PAY_PERSONAL_PAYMENT_METHODS_F
1683: --

Line 1724: pay_payroll_actions ppa

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
1727: and paa.payroll_action_id = ppa.payroll_action_id
1728: and (p_datetrack_mode = hr_api.g_zap

Line 1740: from pay_payroll_actions ppa

1736: and p_datetrack_mode = hr_api.g_zap;
1737: --
1738: cursor csr_payroll_actions_exists is
1739: select null
1740: from pay_payroll_actions ppa
1741: where ppa.org_payment_method_id = p_org_payment_method_id
1742: and (p_datetrack_mode = hr_api.g_zap
1743: or (p_datetrack_mode = hr_api.g_delete
1744: and p_effective_date < ppa.effective_date));

Line 1831: fnd_message.set_token('TABLE_NAME', 'PAY_PAYROLL_ACTIONS');

1827: --
1828: close csr_payroll_actions_exists;
1829: --
1830: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1831: fnd_message.set_token('TABLE_NAME', 'PAY_PAYROLL_ACTIONS');
1832: fnd_message.raise_error;
1833: --
1834: End If;
1835: --