DBA Data[Home] [Help]

APPS.PAY_JP_ZENGIN_TAPE dependencies on PER_ASSIGNMENTS_F

Line 605: per_assignments_f ASSIGN,

601: --
602: CURSOR payment_rule(param1 DATE, param2 NUMBER) IS
603: SELECT target.SEGMENT9
604: FROM hr_soft_coding_keyflex target,
605: per_assignments_f ASSIGN,
606: pay_payrolls_f PAYROLL
607: -- WHERE to_date (param1, 'DD-MON-YYYY')
608: WHERE fnd_date.canonical_to_date(param1)
609: BETWEEN ASSIGN.effective_start_date