APPS.PAY_PYUCSLIS_PKG dependencies on PAY_SECURITY_PAYROLLS

Line 303: pay_security_payrolls sec

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
307: BETWEEN pay.effective_start_date

Line 334: FROM pay_security_payrolls sec

330: AND pay.effective_end_date
331: AND pay.business_group_id + 0 = l_business_group_id
332: AND NOT EXISTS
333: (SELECT NULL
334: FROM pay_security_payrolls sec
335: WHERE sec.security_profile_id = l_security_profile_id
336: AND sec.payroll_id = pay.payroll_id) ;
337: --
338: END IF; -- include payrolls