DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 302: FROM pay_all_payrolls_f pay,

298: p_request_id,
299: p_program_application_id,
300: p_program_id,
301: l_update_date
302: FROM pay_all_payrolls_f pay,
303: pay_security_payrolls sec
304: WHERE sec.security_profile_id = l_security_profile_id
305: AND sec.payroll_id = pay.payroll_id
306: AND l_effective_date

Line 327: FROM pay_all_payrolls_f pay

323: p_request_id,
324: p_program_application_id,
325: p_program_id,
326: l_update_date
327: FROM pay_all_payrolls_f pay
328: WHERE l_effective_date
329: BETWEEN pay.effective_start_date
330: AND pay.effective_end_date
331: AND pay.business_group_id + 0 = l_business_group_id