DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PER_TIME_PERIODS

Line 91: removed reference to per_time_periods

87: to support Third Party payments,
88: fix for bug#2745577.
89: 30-JAN-2003 ssattini 115.16 2771166 Changed the c_payment_period and
90: c_payroll_paydate cursors,
91: removed reference to per_time_periods
92: in c_payment_period and added it to
93: c_payroll_paydate cursor.
94: Fix for bug#2771166.
95: 30-JAN-2003 ssattini 115.17 Tuned the c_assignments cursor

Line 833: from per_time_periods ptp,

829: cursor c_payroll_paydate (cp_assignment_action_id in number,
830: cp_business_group_id in number) IS
831: /* Query to get the Pay Date of Quickpay or Payroll run */
832: select ppa.effective_date,ptp.period_name
833: from per_time_periods ptp,
834: pay_payroll_actions ppa,
835: pay_assignment_actions paa,
836: pay_action_interlocks pai
837: where pai.locking_action_id = cp_assignment_action_id