[Home] [Help]
50: 08-SEP-2008 emunisek 115.99 7373763 Modified procedure process_record to prevent
51: the false entries in the report of SOY changes
52: and to prevent date tracks created for unmodified
53: tax codes
54: 3-Oct-2008 apmishra 115.101 7373763 Re arcs in the file so as to enable the dual maintainence
55: The earlier version of the branch file did not contain the fix,
56: hence rearcs in.
57: 11-Nov_2008 dchindar 115.102 7532289 Changes has been done in cursor csr_mode12, so that process will
58: now update all eligible Tax Code For a employee having more than one-person
67: and reset to 'Y' at the end to ensure row handler validations
68: are not fired when p6/p9/SOY process are submitted.
69: 21-MAY-2009 rlingama 115.107 8497477 Added Employer's PAYE Reference on the output.
70: Earlier the report was sorted by person full name.
71: Now the report would sort by person name with in the individual tax references.
72: 05-OCT-2009 dwkrishn 115.108 8785270 PAYE changes 2009. D0 can be cumulative from 6th APR 2010
73: 21-OCT-2009 rlingama 115.109 8976778 Modified the logic to ensure, If TAX1 77 and TAX1 81 record
74: identifiers exist on an incoming P6/P9 file, we should apply
75: the value which will be either 0.00 or a positive value.
371: -- that are smaller than the current process request_id --
372: ----------------------------------------------------------
373: cursor get_req_cur (c_creator_id in number) IS
374: select 1
375: from dual
376: where exists (select fcr.request_id
377: from fnd_concurrent_requests fcr,
378: fnd_concurrent_programs fcp
379: where fcr.concurrent_program_id = fcp.concurrent_program_id