APPS.AME_MIGRATION_REPORT dependencies on AME_TEMP_OLD_APPROVER_LISTS

Line 383: -- ame_temp_old_approver_lists

379: --
380: -- Before Migration Cursors
381: --
382: --
383: -- ame_temp_old_approver_lists
384: --
385: cursor c_oldAppr_NoWFRoles is
386: select distinct oldappr.person_id person_id
387: from ame_temp_old_approver_lists oldappr

Line 387: from ame_temp_old_approver_lists oldappr

383: -- ame_temp_old_approver_lists
384: --
385: cursor c_oldAppr_NoWFRoles is
386: select distinct oldappr.person_id person_id
387: from ame_temp_old_approver_lists oldappr
388: where oldappr.person_id is not null
389: and not exists (select null
390: from wf_roles wf
391: where wf.orig_system_id = oldappr.person_id

Line 526: --ame_temp_old_approver_lists

522: --
523: -- After Migration Cursors (Already migrated)
524: --
525: --
526: --ame_temp_old_approver_lists
527: --
528: cursor c_migrated_oldAppr is
529: select distinct oldappr.person_id person_id
530: from ame_temp_old_approver_lists oldappr

Line 530: from ame_temp_old_approver_lists oldappr

526: --ame_temp_old_approver_lists
527: --
528: cursor c_migrated_oldAppr is
529: select distinct oldappr.person_id person_id
530: from ame_temp_old_approver_lists oldappr
531: where oldappr.person_id is not null
532: and exists (select null
533: from wf_roles wf
534: where wf.orig_system_id = oldappr.person_id

Line 677: --ame_temp_old_approver_lists

673: --
674: -- *********** Invalid Users in AME ***********
675: --
676: --
677: --ame_temp_old_approver_lists
678: --
679: cursor c_oldAppr_InvalidUser is
680: select distinct oldappr.user_id
681: ,fnd.employee_id person_id

Line 683: from ame_temp_old_approver_lists oldappr

679: cursor c_oldAppr_InvalidUser is
680: select distinct oldappr.user_id
681: ,fnd.employee_id person_id
682: ,fnd.user_name
683: from ame_temp_old_approver_lists oldappr
684: ,fnd_user fnd
685: where oldappr.user_id is not null
686: and oldappr.person_id is null
687: and fnd.employee_id is not null

Line 889: -- ame_temp_old_approver_lists - to be migrated

885: ,description => 'n/a'
886: ,approvers => approversToBeMigrated);
887: end loop;
888: --
889: -- ame_temp_old_approver_lists - to be migrated
890: --
891: for r in c_oldAppr_NoWFRoles loop
892: addApprover(id => r.person_id
893: ,source => 'ame_temp_old_approver_lists'

Line 893: ,source => 'ame_temp_old_approver_lists'

889: -- ame_temp_old_approver_lists - to be migrated
890: --
891: for r in c_oldAppr_NoWFRoles loop
892: addApprover(id => r.person_id
893: ,source => 'ame_temp_old_approver_lists'
894: ,source_object => 'n/a'
895: ,description => 'n/a'
896: ,approvers => approversToBeMigrated);
897: end loop;

Line 982: -- ame_temp_old_approver_lists - to be migrated

978: ,description => 'n/a'
979: ,approvers => migratedApprovers);
980: end loop;
981: --
982: -- ame_temp_old_approver_lists - to be migrated
983: --
984: for r in c_migrated_oldAppr loop
985: addApprover(id => r.person_id
986: ,source => 'ame_temp_old_approver_lists'

Line 986: ,source => 'ame_temp_old_approver_lists'

982: -- ame_temp_old_approver_lists - to be migrated
983: --
984: for r in c_migrated_oldAppr loop
985: addApprover(id => r.person_id
986: ,source => 'ame_temp_old_approver_lists'
987: ,source_object => 'n/a'
988: ,description => 'n/a'
989: ,approvers => migratedApprovers);
990: end loop;

Line 1000: --ame_temp_old_approver_lists

996: --
997: -- ******** Invalid Users ********
998: --
999: --
1000: --ame_temp_old_approver_lists
1001: --
1002: for r in c_oldAppr_InvalidUser loop
1003: addApprover(id => r.person_id
1004: ,user_id => r.user_id

Line 1007: ,source_object => 'ame_temp_old_approver_lists'

1003: addApprover(id => r.person_id
1004: ,user_id => r.user_id
1005: ,user_name => r.user_name
1006: ,source => 'AME Runtime Table'
1007: ,source_object => 'ame_temp_old_approver_lists'
1008: ,description => null
1009: ,approvers => invalidUsers);
1010: end loop;
1011: --