DBA Data[Home] [Help]

APPS.PER_BF_GEN_DATA_PUMP dependencies on PAY_PAYROLLS_F

Line 113: FROM pay_payrolls_f pay

109: l_payroll_id BINARY_INTEGER;
110: BEGIN
111: SELECT pay.payroll_id
112: INTO l_payroll_id
113: FROM pay_payrolls_f pay
114: WHERE pay.payroll_name = p_payroll_name
115: AND pay.business_group_id + 0 = p_business_group_id
116: AND p_effective_date BETWEEN
117: pay.effective_start_date AND pay.effective_end_date;