eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_CHECK5 dependencies on GHR_PROCESS_SF52

Line 486: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then

482: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
483: --BUG# 8264475 modified for dual actions to consider both of the dual noacs in
484: -- dual correction while comparing with cpdf edits as occupation code may change
485: -- in any of the NOACs
486: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
487: if p_effective_date < to_date('2006/04/01','yyyy/mm/dd') then
488: if p_prior_occupation_code <> p_occupation_code and
489: p_prior_occupation_code is not null and
490: p_occupation_code is not null and

Line 510: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

506: hr_utility.raise_error;
507: end if;
508: end if;
509: --added for dual actions
510: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
511: if p_effective_date < to_date('2006/04/01','yyyy/mm/dd') then
512: if p_prior_occupation_code <> p_occupation_code and
513: p_prior_occupation_code is not null and
514: p_occupation_code is not null and

Line 515: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and

511: if p_effective_date < to_date('2006/04/01','yyyy/mm/dd') then
512: if p_prior_occupation_code <> p_occupation_code and
513: p_prior_occupation_code is not null and
514: p_occupation_code is not null and
515: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
516: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
517: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
519:

Line 516: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and

512: if p_prior_occupation_code <> p_occupation_code and
513: p_prior_occupation_code is not null and
514: p_occupation_code is not null and
515: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
516: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
517: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
519:
520: then

Line 517: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and

513: p_prior_occupation_code is not null and
514: p_occupation_code is not null and
515: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
516: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
517: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
519:
520: then
521: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');

Line 518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5

514: p_occupation_code is not null and
515: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
516: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
517: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ('702','703','713','721','740','741','800','850','855') and
518: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
519:
520: then
521: hr_utility.set_message(8301, 'GHR_37511_ALL_PROCEDURE_FAIL');
522: hr_utility.raise_error;

Line 528: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in

524: else
525: if p_prior_occupation_code <> p_occupation_code and
526: p_prior_occupation_code is not null and
527: p_occupation_code is not null and
528: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in
529: ('611','613','702','703','713','721','740','741','800','850','855','890') and
530: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
531: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in
532: ('611','613','702','703','713','721','740','741','800','850','855','890') and

Line 530: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and

526: p_prior_occupation_code is not null and
527: p_occupation_code is not null and
528: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in
529: ('611','613','702','703','713','721','740','741','800','850','855','890') and
530: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
531: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in
532: ('611','613','702','703','713','721','740','741','800','850','855','890') and
533: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
534: then

Line 531: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in

527: p_occupation_code is not null and
528: NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in
529: ('611','613','702','703','713','721','740','741','800','850','855','890') and
530: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
531: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in
532: ('611','613','702','703','713','721','740','741','800','850','855','890') and
533: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
534: then
535: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');

Line 533: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5

529: ('611','613','702','703','713','721','740','741','800','850','855','890') and
530: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> 5 and
531: NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in
532: ('611','613','702','703','713','721','740','741','800','850','855','890') and
533: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> 5
534: then
535: hr_utility.set_message(8301, 'GHR_37163_ALL_PROCEDURE_FAIL');
536: hr_utility.raise_error;
537: end if;

Line 901: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then

897: --BUG# 8264475 modified for dual actions to consider both of the dual noacs in
898: -- dual correction while comparing with cpdf edits as grade may change
899: -- in any of the NOACs
900:
901: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
902: if (p_to_pay_plan = 'GM' or p_to_pay_plan = 'GS') and
903: (p_prior_pay_plan = 'GM' or p_prior_pay_plan = 'GS') and
904: p_grade_or_level <> p_prior_grade and
905: p_grade_or_level is not null and

Line 913: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

909: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
910: hr_utility.raise_error;
911: end if;
912: --Modified for dual actions
913: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
914: if (p_to_pay_plan = 'GM' or p_to_pay_plan = 'GS') and
915: (p_prior_pay_plan = 'GM' or p_prior_pay_plan = 'GS') and
916: p_grade_or_level <> p_prior_grade and
917: p_grade_or_level is not null and

Line 919: (NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and

915: (p_prior_pay_plan = 'GM' or p_prior_pay_plan = 'GS') and
916: p_grade_or_level <> p_prior_grade and
917: p_grade_or_level is not null and
918: p_prior_grade is not null and
919: (NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and
921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then
923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');

Line 920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and

916: p_grade_or_level <> p_prior_grade and
917: p_grade_or_level is not null and
918: p_prior_grade is not null and
919: (NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and
921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then
923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
924: hr_utility.raise_error;

Line 921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and

917: p_grade_or_level is not null and
918: p_prior_grade is not null and
919: (NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and
921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then
923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
924: hr_utility.raise_error;
925: end if;

Line 922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then

918: p_prior_grade is not null and
919: (NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
920: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1) <> '5') and
921: (NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) not in ( '702','703','713','740','741') and
922: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1) <> '5') then
923: hr_utility.set_message(8301, 'GHR_37521_ALL_PROCEDURE_FAIL');
924: hr_utility.raise_error;
925: end if;
926: end if;

Line 1506: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then

1502: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1503: --BUG# 8264475 modified for dual actions to consider both of the dual noacs in
1504: -- dual correction while comparing with cpdf edits as pay plan may change
1505: -- in any of the NOACs
1506: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
1507: if p_effective_date < fnd_date.canonical_to_date('1998/10/01') then
1508: if p_prior_pay_plan <> p_to_pay_plan and
1509: p_prior_pay_plan is not null and
1510: p_to_pay_plan is not null and

Line 1551: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then

1547: hr_utility.raise_error;
1548: end if;
1549: end if;
1550: --Modified for dual actions
1551: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
1552: if p_effective_date < fnd_date.canonical_to_date('1998/10/01') then
1553: if p_prior_pay_plan <> p_to_pay_plan and
1554: p_prior_pay_plan is not null and
1555: p_to_pay_plan is not null and

Line 1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or

1552: if p_effective_date < fnd_date.canonical_to_date('1998/10/01') then
1553: if p_prior_pay_plan <> p_to_pay_plan and
1554: p_prior_pay_plan is not null and
1555: p_to_pay_plan is not null and
1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');

Line 1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and

1553: if p_prior_pay_plan <> p_to_pay_plan and
1554: p_prior_pay_plan is not null and
1555: p_to_pay_plan is not null and
1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1561: hr_utility.raise_error;

Line 1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or

1554: p_prior_pay_plan is not null and
1555: p_to_pay_plan is not null and
1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1561: hr_utility.raise_error;
1562: end if;

Line 1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then

1555: p_to_pay_plan is not null and
1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1557: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1558: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1561: hr_utility.raise_error;
1562: end if;
1563: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then

Line 1567: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',

1563: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1564: if p_prior_pay_plan <> p_to_pay_plan and
1565: p_prior_pay_plan is not null and
1566: p_to_pay_plan is not null and
1567: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1568: '702','703','713','721','740','741','850','855','894') or
1569: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1571: '702','703','713','721','740','741','850','855','894') or

Line 1569: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and

1565: p_prior_pay_plan is not null and
1566: p_to_pay_plan is not null and
1567: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1568: '702','703','713','721','740','741','850','855','894') or
1569: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1571: '702','703','713','721','740','741','850','855','894') or
1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

Line 1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',

1566: p_to_pay_plan is not null and
1567: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1568: '702','703','713','721','740','741','850','855','894') or
1569: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1571: '702','703','713','721','740','741','850','855','894') or
1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');

Line 1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then

1568: '702','703','713','721','740','741','850','855','894') or
1569: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1570: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1571: '702','703','713','721','740','741','850','855','894') or
1572: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1575: hr_utility.raise_error;
1576: end if;

Line 1581: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',

1577: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1578: if p_prior_pay_plan <> p_to_pay_plan and
1579: p_prior_pay_plan is not null and
1580: p_to_pay_plan is not null and
1581: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1582: '611','613','702','703','713','721','740','741','850','855','894') or
1583: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1585: '611','613','702','703','713','721','740','741','850','855','894') or

Line 1583: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and

1579: p_prior_pay_plan is not null and
1580: p_to_pay_plan is not null and
1581: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1582: '611','613','702','703','713','721','740','741','850','855','894') or
1583: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1585: '611','613','702','703','713','721','740','741','850','855','894') or
1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

Line 1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',

1580: p_to_pay_plan is not null and
1581: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1582: '611','613','702','703','713','721','740','741','850','855','894') or
1583: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1585: '611','613','702','703','713','721','740','741','850','855','894') or
1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1588: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');

Line 1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then

1582: '611','613','702','703','713','721','740','741','850','855','894') or
1583: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1584: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1585: '611','613','702','703','713','721','740','741','850','855','894') or
1586: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1587: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1588: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855 or 894 ');
1589: hr_utility.raise_error;
1590: end if;

Line 1595: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',

1591: else
1592: if p_prior_pay_plan <> p_to_pay_plan and
1593: p_prior_pay_plan is not null and
1594: p_to_pay_plan is not null and
1595: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1596: '611','613','702','703','713','721','740','741','850','855','890','894') or
1597: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1599: '611','613','702','703','713','721','740','741','850','855','890','894') or

Line 1597: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and

1593: p_prior_pay_plan is not null and
1594: p_to_pay_plan is not null and
1595: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1596: '611','613','702','703','713','721','740','741','850','855','890','894') or
1597: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1599: '611','613','702','703','713','721','740','741','850','855','890','894') or
1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');

Line 1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',

1594: p_to_pay_plan is not null and
1595: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1596: '611','613','702','703','713','721','740','741','850','855','890','894') or
1597: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1599: '611','613','702','703','713','721','740','741','850','855','890','894') or
1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1602: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');

Line 1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then

1596: '611','613','702','703','713','721','740','741','850','855','890','894') or
1597: substr(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code),1,1)= '5') and
1598: not(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1599: '611','613','702','703','713','721','740','741','850','855','890','894') or
1600: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5') then
1601: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1602: hr_utility.set_message_token('NOA_CODE','611, 613, 702, 703, 713, 721, 740, 741, 850, 855, 890, or 894');
1603: hr_utility.raise_error;
1604: end if;