DBA Data[Home] [Help]

APPS.PAY_OPM_BUS dependencies on PAY_ALL_PAYROLLS_F

Line 720: -- (p_base_table_name => 'pay_all_payrolls_f'

716: l_table_name := 'run type org methods';
717: Raise l_rows_exist;
718: End If;
719: -- If (dt_api.rows_exist
720: -- (p_base_table_name => 'pay_all_payrolls_f'
721: -- ,p_base_key_column => 'default_payment_method_id'
722: -- ,p_base_key_value => p_org_payment_method_id
723: -- ,p_from_date => p_validation_start_date
724: -- ,p_to_date => p_validation_end_date

Line 1680: -- PAY_ALL_PAYROLLS_F,

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: --
1684: -- Pre-conditions :

Line 1748: from pay_all_payrolls_f ppa

1744: and p_effective_date < ppa.effective_date));
1745: --
1746: cursor csr_payrolls_exists is
1747: select null
1748: from pay_all_payrolls_f ppa
1749: where ppa.default_payment_method_id = p_org_payment_method_id
1750: and ppa.business_group_id = p_business_group_id;
1751: --
1752: begin

Line 1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');

1849: close csr_payrolls_exists;
1850: --
1851: if (p_datetrack_mode = hr_api.g_zap) then
1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else
1856: fnd_message.set_name('PAY','HR_6739_PAYM_NO_METH');
1857: fnd_message.raise_error;