[Home] [Help]
50: --300.16.2
51: -- added 'Z2U' on 22-jul-1998
52: -- Update/Change Date By Effective Date Comment
53: -- 10/2 08/13/99 vravikan 01-Aug-1999 Change R5M to R6M
54: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/08/01') then
55: if p_First_NOAC_Lookup_Code= '312'
56: and
57: NOT ( p_First_Action_NOA_LA_Code1 in
58: ('RPM','RPR','RQM','RRM','RSM','RTM','RTR','RUM','RWM',
79:
80: --300.19.2
81: -- Update/Change Date By Effective Date Comment
82: -- 10/2 08/13/99 vravikan 01-Aug-1999 Change R5M to R6M
83: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/08/01') then
84: if p_First_NOAC_Lookup_Code= '317'
85: and
86: NOT ( p_First_Action_NOA_LA_Code1 in
87: ('RPM','RQM','RRM','RSM','RUM','R6M','R7M','R8M','R9M','V8V','ZVB','ZVC') AND
201:
202: --315.02.2
203: -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
204: -- added 'Z2U' on 22-jul-1998
205: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
206: if p_First_NOAC_Lookup_Code= '385'
207: and
208: NOT ( p_First_Action_NOA_LA_Code1 in
209: ( 'HAM','L2M','L4M','L5M','L6M','L8M','LXM','UFM','VGL',
275:
276: --320.14.2
277: -- Update Date By Effective Date Comment
278: -- 8 01/28/99 vravikan 01/01/99 End date
279: if p_effective_date < fnd_date.canonical_to_date('19'||'99/01/01') then
280: if p_First_NOAC_Lookup_Code= '462'
281: and
282: NOT ( p_First_Action_NOA_LA_Code1 in
283: ( 'GFM','R4M','UFM','V8V','ZVB') AND
343: --320.26.2
344: -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
345:
346: -- added legal authority Z2W on 9-oct-98
347: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
348: if p_First_NOAC_Lookup_Code= '480'
349: and
350: NOT ( p_First_Action_NOA_LA_Code1 in
351: ('UFM','V3M','VGL','Z2W','ZSP','ZVB','ZVC') AND
389: -- upd49 19-Jan-07 Raju From Beginning Bug#5619873 add BAF
390: -- Upd 54 12-Jun-07 vmididho From Begining delete BAF
391: --
392: if p_effective_date >= to_date('19'||'99/12/01','yyyy/mm/dd') then
393: if p_effective_date < fnd_date.canonical_to_date('2005/02/01') then --Bug#5619873
394: if p_First_NOAC_Lookup_Code= '500' and
395: NOT ( p_First_Action_NOA_LA_Code1 in
396: ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
397: 'BAB','BAC','BAD','BAE','BYO',
727: -- added 'Z2U' on 22-jul-1998
728: -- Update/Change Date By Effective Date Comment
729: -- 8/5 03/09/99 vravikan Add BWA
730: -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM
731: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then
732: if p_First_NOAC_Lookup_Code= '507'
733: and
734: NOT ( p_First_Action_NOA_LA_Code1 in
735: ('ABL','ABM','ABR','ABS','AYM','BWA','BWM',
889: -- 14-SEP-2004 Madhuri
890: -------------------------------------------------------------------------------------
891: IF ( p_effective_date <= to_date('20'||'04/08/31','yyyy/mm/dd') ) THEN
892:
893: IF p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
894: if p_First_NOAC_Lookup_Code= '512'
895: and
896: NOT ( p_First_Action_NOA_LA_Code1 in
897: ('ABL','ABM','AYM','BWM','HAM',
1900: --329.30.2
1901: -- Update Date By Effective Date Comment
1902: -- 05-NOV-03 ajose From the begining Added the Edit as a part of EOY03 changes
1903: --upd47 26-Jun-06 Raju From 01-May-2006 Terminate the edit
1904: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
1905: IF p_First_NOAC_Lookup_Code= '849' AND
1906: NOT ( p_First_Action_NOA_LA_Code1 IN
1907: ('V9N','V9P') AND
1908: p_First_Action_NOA_LA_Code2 IN