APPS.PAY_PYUCSLIS_PKG dependencies on PAY_SECURITY_PAYROLLS

Line 363: pay_security_payrolls sec

359: p_program_application_id,
360: p_program_id,
361: l_update_date
362: FROM pay_all_payrolls_f pay,
363: pay_security_payrolls sec
364: WHERE sec.security_profile_id = l_security_profile_id
365: AND sec.payroll_id = pay.payroll_id;
366: /* Coomented for bug 8219374
367: AND l_effective_date

Line 398: FROM pay_security_payrolls sec

394: AND */
395: pay.business_group_id + 0 = l_business_group_id
396: AND NOT EXISTS
397: (SELECT NULL
398: FROM pay_security_payrolls sec
399: WHERE sec.security_profile_id = l_security_profile_id
400: AND sec.payroll_id = pay.payroll_id) ;
401: --
402: END IF; -- include payrolls