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 816: from per_time_periods ptp,

812: cursor c_payroll_paydate (cp_assignment_action_id in number,
813: cp_business_group_id in number) IS
814: /* Query to get the Pay Date of Quickpay or Payroll run */
815: select ppa.effective_date,ptp.period_name
816: from per_time_periods ptp,
817: pay_payroll_actions ppa,
818: pay_assignment_actions paa,
819: pay_action_interlocks pai
820: where pai.locking_action_id = cp_assignment_action_id