DBA Data[Home] [Help]

APPS.PAY_GB_ONLINE_SOE dependencies on PER_TIME_PERIODS

Line 617: per_time_periods ptp

613: cursor csr_get_action_id(asg_id number) is
614: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
615: from pay_payroll_actions pa,
616: pay_assignment_actions aa,
617: per_time_periods ptp
618: where aa.action_status in ('C','S') --Modified for the bug 10066755
619: --where aa.action_status = 'C'
620: and pa.payroll_action_id = aa.payroll_action_id
621: and aa.assignment_id = asg_id