1: PACKAGE BODY pay_ca_payreg_extract_pkg AS
2: /* $Header: pycaprpe.pkb 120.5 2006/11/13 06:07:15 schowta noship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ca_payreg_extract_pkg
21:
22: Description : Package for the Payment Report. The package
23: generated the output file in the specified user
24: format. The current formats supported are
131:
132: 26-Sep-2006 schowta 115.27 5383895 - Following modifications are done. search for 5383895
133: for all the changes done.
134:
135: a. pay_ca_payreg_extract_pkg > c_payment_period and
136: other cursors the join to date_earned has been changed to effective_date
137: in all instances except in c_payroll_paydate
138:
139: cursor c_tp_pmt_check is merged with c_assignments cursor.
150:
151: gv_html_start_data VARCHAR2(5) := '
1442: /* hr_utility.trace_off; */
1443:
1444: END payment_extract;
1445:
1446: end pay_ca_payreg_extract_pkg;