DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on PAY_RUN_TYPES_F

Line 569: from pay_run_types_f_tl t,

565: and payroll_id = l_payroll_id;
566:
567: cursor cur_payroll_run_type is
568: select t.run_type_name
569: from pay_run_types_f_tl t,
570: pay_run_types_f r
571: where r.run_type_id = to_number(p_payroll_run_type)
572: and r.run_type_id = t.run_type_id
573: and t.language = userenv('LANG')

Line 570: pay_run_types_f r

566:
567: cursor cur_payroll_run_type is
568: select t.run_type_name
569: from pay_run_types_f_tl t,
570: pay_run_types_f r
571: where r.run_type_id = to_number(p_payroll_run_type)
572: and r.run_type_id = t.run_type_id
573: and t.language = userenv('LANG')
574: and fnd_date.canonical_to_date(p_date_earned)