DBA Data[Home] [Help]

APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 239: From pay_payrolls_f

235: And business_group_id +0 = organization_id;
236:
237: Select payroll_name
238: into l_payroll_name
239: From pay_payrolls_f
240: Where payroll_id = l_payroll_id
241: And g_end_period_date between effective_start_date and effective_end_date;
242:
243: Exception

Line 314: pay_payrolls_f ppf,

310:
311: sqlstr :=
312: 'select distinct ass.person_id
313: from per_assignments_f ass,
314: pay_payrolls_f ppf,
315: pay_payroll_actions ppa
316: where ppa.payroll_action_id = :payroll_action_id
317: and ass.business_group_id = ppa.business_group_id
318: and ass.assignment_type = ''E''