DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP202 dependencies on PAY_PAYROLLS_F

Line 65: ,pay_payrolls_f ppf

61: ,pay_payroll_actions ppa1
62: ,pay_assignment_actions paa2
63: ,pay_payroll_actions ppa2
64: ,pay_action_interlocks pai
65: ,pay_payrolls_f ppf
66: WHERE
67: paa1.assignment_id = p_assignment_id
68: AND paa1.action_status IN ('C','S') -- 10229494
69: AND paa1.payroll_action_id = ppa1.payroll_action_id

Line 264: l_period_type pay_payrolls_f.period_type%TYPE;

260: le_rec csr_le%ROWTYPE ;
261: addr_rec csr_address%ROWTYPE ;
262: xml_ctr number;
263: l_pay VARCHAR2(150);
264: l_period_type pay_payrolls_f.period_type%TYPE;
265: l_check VARCHAR2(1);
266: le_cvr_rec csr_le_cvr%ROWTYPE; --Bug 5049222 fix
267: l_payroll_proc_start_date DATE ;
268: