DBA Data[Home] [Help]

APPS.PAY_GB_ONLINE_SOE dependencies on PER_TIME_PERIODS

Line 612: per_time_periods ptp

608: cursor csr_get_action_id(asg_id number) is
609: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
610: from pay_payroll_actions pa,
611: pay_assignment_actions aa,
612: per_time_periods ptp
613: where aa.action_status = 'C'
614: and pa.payroll_action_id = aa.payroll_action_id
615: and aa.assignment_id = asg_id
616: and ptp.payroll_id = pa.payroll_id