DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP201 dependencies on PAY_PAYROLLS_F

Line 64: ,pay_payrolls_f ppf

60: ,pay_payroll_actions ppa1
61: ,pay_assignment_actions paa2
62: ,pay_payroll_actions ppa2
63: ,pay_action_interlocks pai
64: ,pay_payrolls_f ppf
65: WHERE
66: paa1.assignment_id = p_assignment_id
67: AND paa1.action_status = 'C'
68: AND paa1.payroll_action_id = ppa1.payroll_action_id

Line 262: ,pay_payrolls_f ppf

258: ,pay_element_types_f petf
259: ,per_jobs pj
260: ,pay_element_entry_values_f peevf
261: ,pay_input_values_f pivf
262: ,pay_payrolls_f ppf
263: WHERE
264: paaf.person_id = p_person_id
265: AND paaf.assignment_id = NVL(p_assignment_id,paaf.assignment_id)
266: AND paaf.assignment_status_type_id = 1

Line 389: --l_period_type pay_payrolls_f.period_type%TYPE;

385: asg_rec csr_asg%ROWTYPE ;
386: le_rec csr_le%ROWTYPE ;
387: xml_ctr number;
388: l_pay VARCHAR2(150);
389: --l_period_type pay_payrolls_f.period_type%TYPE;
390: l_check VARCHAR2(1);
391: le_cvr_rec csr_le_cvr%ROWTYPE; --Bug 5049222 fix
392: l_absence_days NUMBER ;
393: l_section27 hr_organization_information.org_information1%TYPE;