APPS.BEN_PYR_BUS dependencies on PAY_ALL_PAYROLLS_F

Line 155: -- PAY_ALL_PAYROLLS_F table.

151: --
152: -- Description
153: -- This procedure is used to check that the foreign key for the table
154: -- is created properly. a corresponding record should exist in the
155: -- PAY_ALL_PAYROLLS_F table.
156: --
157: -- Pre Conditions
158: -- None.
159: --

Line 161: -- payroll_id FK of pointing to PAY_ALL_PAYROLLS_F tables.

157: -- Pre Conditions
158: -- None.
159: --
160: -- In Parameters
161: -- payroll_id FK of pointing to PAY_ALL_PAYROLLS_F tables.
162: -- business_group_id or record being inserted or updated
163: -- effective_date Effective Date of session
164: --
165: -- Post Success

Line 181: from PAY_ALL_PAYROLLS_F

177: --
178: l_proc varchar2(72) := g_package||'chk_payroll_id';
179: l_dummy varchar2(1);
180: cursor c1 is select null
181: from PAY_ALL_PAYROLLS_F
182: where payroll_id = p_payroll_id
183: and p_effective_date between
184: nvl(effective_start_date, p_effective_date)
185: and nvl(effective_end_date, p_effective_date)