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.HR_FR_SEED_PKG dependencies on PER_ALT_LOOKUPS_PKG

Line 13354: per_alt_lookups_pkg.run_process

13350: --Initialising Parameters
13351: lc_legislation_code := 'FR';
13352: --Initialising Parameters
13353: --
13354: per_alt_lookups_pkg.run_process
13355: (errbuf => lc_errbuf
13356: ,retcode => ln_retcode
13357: ,p_business_group_id => p_business_group_id
13358: ,p_application_id => 800

Line 13366: per_alt_lookups_pkg.run_process

13362: ,p_required_defaults => 'Other'
13363: ,p_default_value => NULL
13364: ,p_legislation_code => lc_legislation_code);
13365: --
13366: per_alt_lookups_pkg.run_process
13367: (errbuf => lc_errbuf
13368: ,retcode => ln_retcode
13369: ,p_business_group_id => p_business_group_id
13370: ,p_application_id => 800

Line 13378: per_alt_lookups_pkg.run_process

13374: ,p_required_defaults => 'Other'
13375: ,p_default_value => NULL
13376: ,p_legislation_code => lc_legislation_code);
13377: --
13378: per_alt_lookups_pkg.run_process
13379: (errbuf => lc_errbuf
13380: ,retcode => ln_retcode
13381: ,p_business_group_id => p_business_group_id
13382: ,p_application_id => 800

Line 13390: per_alt_lookups_pkg.run_process

13386: ,p_required_defaults => 'None'
13387: ,p_default_value => NULL
13388: ,p_legislation_code => lc_legislation_code);
13389: --
13390: per_alt_lookups_pkg.run_process
13391: (errbuf => lc_errbuf
13392: ,retcode => ln_retcode
13393: ,p_business_group_id => p_business_group_id
13394: ,p_application_id => 800

Line 13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');

13410: hr_utility.set_location('***** do_mmo_seed_data - FR_STARTING_REASON -> ' || to_char(p_business_group_id) || '/' || lc_legislation_code, 5);
13411: --
13412: -- Seeded data for FR_STARTING_REASON (and all its related rows) / MMO_STARTING_CATEGORY
13413: --
13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');
13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');

Line 13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');

13411: --
13412: -- Seeded data for FR_STARTING_REASON (and all its related rows) / MMO_STARTING_CATEGORY
13413: --
13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');
13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');

Line 13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');

13412: -- Seeded data for FR_STARTING_REASON (and all its related rows) / MMO_STARTING_CATEGORY
13413: --
13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');
13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');

Line 13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');

13413: --
13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');
13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');

Line 13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');

13414: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_COMPANY','TR');
13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');

Line 13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');

13415: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');
13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');

Line 13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');

13416: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','CHANGE_OF_JOB','TR');
13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');
13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');
13424: --

Line 13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');

13417: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_FIXED_TERM','RD');
13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');
13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');
13424: --
13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);

Line 13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');

13418: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','HIRED_PERMANENT','RI');
13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');
13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');
13424: --
13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);
13426: -- Seeded data for FR_ENDING_REASON (and all its related rows) / MMO_ENDING_CATEGORY

Line 13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');

13419: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','OTHER','AU');
13420: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_FIXED_TERM','RI');
13421: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','REHIRED_PERMANENT','RD');
13422: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','RECLASS','AU');
13423: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_STARTING_REASON','MMO_STARTING_CATEGORY','TEMPORARY_REPLACEMENT','AU');
13424: --
13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);
13426: -- Seeded data for FR_ENDING_REASON (and all its related rows) / MMO_ENDING_CATEGORY
13427: --

Line 13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');

13424: --
13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);
13426: -- Seeded data for FR_ENDING_REASON (and all its related rows) / MMO_ENDING_CATEGORY
13427: --
13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');
13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');

Line 13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');

13425: hr_utility.set_location('do_mmo_seed_data - FR_ENDING_REASON ', 10);
13426: -- Seeded data for FR_ENDING_REASON (and all its related rows) / MMO_ENDING_CATEGORY
13427: --
13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');
13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');

Line 13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');

13426: -- Seeded data for FR_ENDING_REASON (and all its related rows) / MMO_ENDING_CATEGORY
13427: --
13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');
13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');

Line 13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');

13427: --
13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');
13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');

Line 13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');

13428: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_COMPANY','TR');
13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');

Line 13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');

13429: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_ESTABLISHMENT','TR');
13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');

Line 13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');

13430: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','CHANGE_OF_JOB','DM');
13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');

Line 13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');

13431: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','DEATH','AU');
13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');

Line 13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');

13432: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','ECONOMIC_REDUNDANCY','LA');
13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');

Line 13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');

13433: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_FIXED_TERM','FD');
13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');

Line 13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');

13434: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','END_PROBATION_PERIOD','ED');
13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');

Line 13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');

13435: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','NATIONAL_SERVICE','SN');
13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');

Line 13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');

13436: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','OTHER','AU');
13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');

Line 13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');

13437: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REDUNDANCY','LA');
13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');

Line 13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');

13438: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','REPLACEMENT','AU');
13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');

Line 13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');

13439: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RESIGNATION','DM');
13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');

Line 13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');

13440: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','RETIREMENT','RT');
13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');

Line 13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');

13441: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','EARLY_RETIREMENT','RT');
13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');
13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');

Line 13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');

13442: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','VOLUNTARY_RETIREMENT','RT');
13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');
13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');
13450: --

Line 13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');

13443: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','MUTUAL_AGREEMENT_BREACH','AU');
13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');
13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');
13450: --
13451: hr_utility.set_location('do_mmo_seed_data - Leaving ', 30);

Line 13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');

13444: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','G','LA');
13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');
13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');
13450: --
13451: hr_utility.set_location('do_mmo_seed_data - Leaving ', 30);
13452: --

Line 13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');

13445: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','SERIOUS_MISCONDUCT','LA');
13446: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY','LA');
13447: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','PHYSICAL_INABILITY_WA','LA');
13448: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','R','RT');
13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');
13450: --
13451: hr_utility.set_location('do_mmo_seed_data - Leaving ', 30);
13452: --
13453: per_alt_lookups_pkg.run_process

Line 13453: per_alt_lookups_pkg.run_process

13449: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ENDING_REASON','MMO_ENDING_CATEGORY','D','AU');
13450: --
13451: hr_utility.set_location('do_mmo_seed_data - Leaving ', 30);
13452: --
13453: per_alt_lookups_pkg.run_process
13454: (errbuf => lc_errbuf
13455: ,retcode => ln_retcode
13456: ,p_business_group_id => p_business_group_id
13457: ,p_application_id => 800

Line 13466: per_alt_lookups_pkg.run_process

13462: ,p_default_value => 'N'
13463: ,p_legislation_code => lc_legislation_code);
13464: --
13465: --Bug #4068197
13466: per_alt_lookups_pkg.run_process
13467: (errbuf => lc_errbuf
13468: ,retcode => ln_retcode
13469: ,p_business_group_id => p_business_group_id
13470: ,p_application_id => 800

Line 13480: per_alt_lookups_pkg.run_process

13476: ,p_legislation_code => lc_legislation_code);
13477: --Bug #4068197
13478: --
13479:
13480: per_alt_lookups_pkg.run_process
13481: (errbuf => lc_errbuf
13482: ,retcode => ln_retcode
13483: ,p_business_group_id => p_business_group_id
13484: ,p_application_id => 800

Line 13493: per_alt_lookups_pkg.run_process

13489: ,p_default_value => 'U'
13490: ,p_legislation_code => lc_legislation_code);
13491: --
13492: --Bug #4183533
13493: per_alt_lookups_pkg.run_process
13494: (errbuf => lc_errbuf
13495: ,retcode => ln_retcode
13496: ,p_business_group_id => p_business_group_id
13497: ,p_application_id => 800

Line 13513: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3862','Y');

13509: -- (combination table_name/column)
13510: ---------------------------------------------------------------------
13511: -- Seeded data for FR_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13512: --
13513: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3862','Y');
13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');
13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');

Line 13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');

13510: ---------------------------------------------------------------------
13511: -- Seeded data for FR_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13512: --
13513: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3862','Y');
13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');
13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');

Line 13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');

13511: -- Seeded data for FR_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13512: --
13513: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3862','Y');
13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');
13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');

Line 13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');

13512: --
13513: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3862','Y');
13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');
13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');

Line 13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');

13513: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3862','Y');
13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');
13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');

Line 13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');

13514: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','3863','Y');
13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');

Line 13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');

13515: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','4802','Y');
13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');

Line 13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');

13516: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5223','Y');
13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');

Line 13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');

13517: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5315','Y');
13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');

Line 13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');

13518: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5317','Y');
13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');

Line 13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');

13519: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5441','Y');
13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');

Line 13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');

13520: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5445','Y');
13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');

Line 13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');

13521: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','5510','Y');
13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');

Line 13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');

13522: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6234','Y');
13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');

Line 13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');

13523: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6241','Y');
13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');

Line 13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');

13524: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6242','Y');
13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');

Line 13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');

13525: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6243','Y');
13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');

Line 13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');

13526: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6244','Y');
13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');

Line 13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');

13527: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6245','Y');
13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');

Line 13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');

13528: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6246','Y');
13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');

Line 13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');

13529: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6331','Y');
13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');

Line 13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');

13530: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6341','Y');
13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');

Line 13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');

13531: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6343','Y');
13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');

Line 13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');

13532: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6411','Y');
13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');

Line 13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');

13533: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6412','Y');
13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');

Line 13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');

13534: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6415','Y');
13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');

Line 13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');

13535: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6511','Y');
13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');

Line 13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');

13536: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6512','Y');
13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');

Line 13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');

13537: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6513','Y');
13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');
13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');

Line 13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');

13538: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6522','Y');
13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');
13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');
13546: --

Line 13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');

13539: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6531','Y');
13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');
13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');
13546: --
13547: hr_utility.set_location('do_d2_seed_data ', 10);

Line 13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');

13540: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6532','Y');
13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');
13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');
13546: --
13547: hr_utility.set_location('do_d2_seed_data ', 10);
13548: --

Line 13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');

13541: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6741','Y');
13542: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6742','Y');
13543: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6841','Y');
13544: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6911','Y');
13545: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_PCS_CODE','FR_D2_PARTICULAR','6921','Y');
13546: --
13547: hr_utility.set_location('do_d2_seed_data ', 10);
13548: --
13549: -- seeded data for FR_EMPLOYMENT / FR_D2_CATEGORY

Line 13551: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FR','F');

13547: hr_utility.set_location('do_d2_seed_data ', 10);
13548: --
13549: -- seeded data for FR_EMPLOYMENT / FR_D2_CATEGORY
13550: --
13551: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FR','F');
13552: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FT','F');
13553: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PR','P');
13554: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PT','P');
13555:

Line 13552: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FT','F');

13548: --
13549: -- seeded data for FR_EMPLOYMENT / FR_D2_CATEGORY
13550: --
13551: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FR','F');
13552: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FT','F');
13553: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PR','P');
13554: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PT','P');
13555:
13556: -- Seeded data for FR_NEW_PCS_CODE (and related rows) / FR_D2_PARTICULAR

Line 13553: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PR','P');

13549: -- seeded data for FR_EMPLOYMENT / FR_D2_CATEGORY
13550: --
13551: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FR','F');
13552: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FT','F');
13553: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PR','P');
13554: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PT','P');
13555:
13556: -- Seeded data for FR_NEW_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13557: --

Line 13554: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PT','P');

13550: --
13551: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FR','F');
13552: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','FT','F');
13553: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PR','P');
13554: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PT','P');
13555:
13556: -- Seeded data for FR_NEW_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13557: --
13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');

Line 13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');

13554: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'EMP_CAT','FR_D2_CATEGORY','PT','P');
13555:
13556: -- Seeded data for FR_NEW_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13557: --
13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');
13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');
13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');

Line 13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');

13555:
13556: -- Seeded data for FR_NEW_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13557: --
13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');
13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');
13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');

Line 13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');

13556: -- Seeded data for FR_NEW_PCS_CODE (and related rows) / FR_D2_PARTICULAR
13557: --
13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');
13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');
13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');

Line 13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');

13557: --
13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');
13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');
13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');

Line 13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');

13558: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389B','Y');
13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');
13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');

Line 13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');

13559: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','389C','Y');
13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');

Line 13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');

13560: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','480B','Y');
13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');

Line 13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');

13561: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','526E','Y');
13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');

Line 13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');

13562: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533A','Y');
13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');

Line 13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');

13563: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','533B','Y');
13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');

Line 13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');

13564: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534A','Y');
13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');

Line 13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');

13565: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','534B','Y');
13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');

Line 13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');

13566: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546A','Y');
13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');

Line 13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');

13567: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546D','Y');
13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');

Line 13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');

13568: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','546E','Y');
13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');

Line 13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');

13569: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','553B','Y');
13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');

Line 13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');

13570: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','624D','Y');
13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');

Line 13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');

13571: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621A','Y');
13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');

Line 13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');

13572: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621B','Y');
13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');

Line 13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');

13573: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621C','Y');
13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');

Line 13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');

13574: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621E','Y');
13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');

Line 13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');

13575: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','621G','Y');
13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');

Line 13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');

13576: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632A','Y');
13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');

Line 13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');

13577: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632C','Y');
13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');

Line 13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');

13578: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','632E','Y');
13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');

Line 13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');

13579: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641A','Y');
13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');

Line 13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');

13580: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','641B','Y');
13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');

Line 13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');

13581: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','643A','Y');
13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');

Line 13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');

13582: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651A','Y');
13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');

Line 13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');

13583: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','651B','Y');
13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');

Line 13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');

13584: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','652B','Y');
13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');
13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');

Line 13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');

13585: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654B','Y');
13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');
13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');
13593: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','692A','Y');

Line 13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');

13586: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','654C','Y');
13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');
13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');
13593: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','692A','Y');
13594:

Line 13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');

13587: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656B','Y');
13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');
13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');
13593: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','692A','Y');
13594:
13595:

Line 13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');

13588: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','656C','Y');
13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');
13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');
13593: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','692A','Y');
13594:
13595:
13596: create_item_types(P_BUSINESS_GROUP_ID => p_business_group_id);

Line 13593: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','692A','Y');

13589: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671C','Y');
13590: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','671D','Y');
13591: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','681A','Y');
13592: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','691A','Y');
13593: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_NEW_PCS_CODE','FR_D2_PARTICULAR','692A','Y');
13594:
13595:
13596: create_item_types(P_BUSINESS_GROUP_ID => p_business_group_id);
13597: create_key_types(P_BUSINESS_GROUP_ID => p_business_group_id);

Line 13811: per_alt_lookups_pkg.run_process

13807: P_USER_KEY_UNITS => 'T');
13808: -- added rows for French Absence reporting
13809: -- FR_ABS_CATG_ADS_ABS_CODE--
13810: --
13811: per_alt_lookups_pkg.run_process
13812: (errbuf => lc_errbuf
13813: ,retcode => ln_retcode
13814: ,p_business_group_id => p_business_group_id
13815: ,p_application_id => 800

Line 13826: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_MAIN_HOLIDAY','COP');

13822: --
13823: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13824: -- Populate rows (each a lookup code) with respective values
13825: --
13826: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_MAIN_HOLIDAY','COP');
13827:
13828: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_RTT_HOLIDAY','COP');
13829:
13830: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_ADDITIONAL_HOLIDAY','COP');

Line 13828: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_RTT_HOLIDAY','COP');

13824: -- Populate rows (each a lookup code) with respective values
13825: --
13826: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_MAIN_HOLIDAY','COP');
13827:
13828: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_RTT_HOLIDAY','COP');
13829:
13830: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_ADDITIONAL_HOLIDAY','COP');
13831:
13832: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'HOLS', 'COP');

Line 13830: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_ADDITIONAL_HOLIDAY','COP');

13826: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_MAIN_HOLIDAY','COP');
13827:
13828: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_RTT_HOLIDAY','COP');
13829:
13830: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_ADDITIONAL_HOLIDAY','COP');
13831:
13832: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'HOLS', 'COP');
13833:
13834: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','S','MAL');

Line 13832: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'HOLS', 'COP');

13828: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_RTT_HOLIDAY','COP');
13829:
13830: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_ADDITIONAL_HOLIDAY','COP');
13831:
13832: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'HOLS', 'COP');
13833:
13834: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','S','MAL');
13835:
13836: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','M','MAT');

Line 13834: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','S','MAL');

13830: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'FR_ADDITIONAL_HOLIDAY','COP');
13831:
13832: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'HOLS', 'COP');
13833:
13834: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','S','MAL');
13835:
13836: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','M','MAT');
13837:
13838: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','PL','PAT'); --Check with paternity designs

Line 13836: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','M','MAT');

13832: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'HOLS', 'COP');
13833:
13834: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','S','MAL');
13835:
13836: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','M','MAT');
13837:
13838: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','PL','PAT'); --Check with paternity designs
13839:
13840: -- Any further absence categories

Line 13838: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','PL','PAT'); --Check with paternity designs

13834: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','S','MAL');
13835:
13836: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','M','MAT');
13837:
13838: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_ABS_CODE','ADS_ABSENCE_CODE','PL','PAT'); --Check with paternity designs
13839:
13840: -- Any further absence categories
13841: --
13842: --

Line 13845: per_alt_lookups_pkg.run_process

13841: --
13842: --
13843: -- FR_WORK_INC_ADS_ABS_CODE --
13844: --
13845: per_alt_lookups_pkg.run_process
13846: (errbuf => lc_errbuf
13847: ,retcode => ln_retcode
13848: ,p_business_group_id => p_business_group_id
13849: ,p_application_id => 800

Line 13861: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'O','MP');

13857: --
13858: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13859: -- Populate rows (each a lookup code) with respective values
13860: --
13861: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'O','MP');
13862: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'R','AT');
13863: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'W','WT');
13864: --
13865: --any more work incidents

Line 13862: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'R','AT');

13858: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13859: -- Populate rows (each a lookup code) with respective values
13860: --
13861: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'O','MP');
13862: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'R','AT');
13863: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'W','WT');
13864: --
13865: --any more work incidents
13866: --

Line 13863: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'W','WT');

13859: -- Populate rows (each a lookup code) with respective values
13860: --
13861: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'O','MP');
13862: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'R','AT');
13863: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_WORK_INC_ADS_ABS_CODE','ADS_ABSENCE_CODE', 'W','WT');
13864: --
13865: --any more work incidents
13866: --
13867: --

Line 13870: per_alt_lookups_pkg.run_process

13866: --
13867: --
13868: -- FR_ABS_CATG_ADS_STATUS_CODE --
13869: --
13870: per_alt_lookups_pkg.run_process
13871: (errbuf => lc_errbuf
13872: ,retcode => ln_retcode
13873: ,p_business_group_id => p_business_group_id
13874: ,p_application_id => 800

Line 13886: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_MAIN_HOLIDAY','FR_PAID_HOLIDAY');

13882: --
13883: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13884: -- Populate rows (each a lookup code) with respective values
13885: --
13886: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_MAIN_HOLIDAY','FR_PAID_HOLIDAY');
13887: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_ADDITIONAL_HOLIDAY','FR_PAID_HOLIDAY');
13888: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_RTT_HOLIDAY','FR_PAID_HOLIDAY');
13889: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'HOLS','FR_UNPAID_HOLIDAY');
13890: --

Line 13887: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_ADDITIONAL_HOLIDAY','FR_PAID_HOLIDAY');

13883: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13884: -- Populate rows (each a lookup code) with respective values
13885: --
13886: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_MAIN_HOLIDAY','FR_PAID_HOLIDAY');
13887: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_ADDITIONAL_HOLIDAY','FR_PAID_HOLIDAY');
13888: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_RTT_HOLIDAY','FR_PAID_HOLIDAY');
13889: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'HOLS','FR_UNPAID_HOLIDAY');
13890: --
13891: -- any more absence categories

Line 13888: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_RTT_HOLIDAY','FR_PAID_HOLIDAY');

13884: -- Populate rows (each a lookup code) with respective values
13885: --
13886: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_MAIN_HOLIDAY','FR_PAID_HOLIDAY');
13887: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_ADDITIONAL_HOLIDAY','FR_PAID_HOLIDAY');
13888: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_RTT_HOLIDAY','FR_PAID_HOLIDAY');
13889: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'HOLS','FR_UNPAID_HOLIDAY');
13890: --
13891: -- any more absence categories
13892: --

Line 13889: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'HOLS','FR_UNPAID_HOLIDAY');

13885: --
13886: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_MAIN_HOLIDAY','FR_PAID_HOLIDAY');
13887: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_ADDITIONAL_HOLIDAY','FR_PAID_HOLIDAY');
13888: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'FR_RTT_HOLIDAY','FR_PAID_HOLIDAY');
13889: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_ABS_CATG_ADS_STATUS_CODE','ADS_STATUS', 'HOLS','FR_UNPAID_HOLIDAY');
13890: --
13891: -- any more absence categories
13892: --
13893: --

Line 13896: per_alt_lookups_pkg.run_process

13892: --
13893: --
13894: -- FR_TERM_REASON_ADS_STATUS_CODE --
13895: --
13896: per_alt_lookups_pkg.run_process
13897: (errbuf => lc_errbuf
13898: ,retcode => ln_retcode
13899: ,p_business_group_id => p_business_group_id
13900: ,p_application_id => 800

Line 13912: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE1','FR_DISMISSAL');

13908: --
13909: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13910: -- Populate rows (each a lookup code) with respective values
13911: --
13912: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE1','FR_DISMISSAL');
13913: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE2','FR_DISMISSAL');
13914: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'RESIGNATION','FR_RESIGNATION');
13915: --
13916: -- any more termination reasons

Line 13913: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE2','FR_DISMISSAL');

13909: -- Seeded data for User table Name (Lookup Type) (and all its related rows) /Column name
13910: -- Populate rows (each a lookup code) with respective values
13911: --
13912: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE1','FR_DISMISSAL');
13913: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE2','FR_DISMISSAL');
13914: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'RESIGNATION','FR_RESIGNATION');
13915: --
13916: -- any more termination reasons
13917:

Line 13914: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'RESIGNATION','FR_RESIGNATION');

13910: -- Populate rows (each a lookup code) with respective values
13911: --
13912: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE1','FR_DISMISSAL');
13913: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'DISMISS_CODE2','FR_DISMISSAL');
13914: per_alt_lookups_pkg.update_instance_value(p_business_group_id,lc_legislation_code,'FR_TERM_REASON_ADS_STATUS_CODE','ADS_STATUS', 'RESIGNATION','FR_RESIGNATION');
13915: --
13916: -- any more termination reasons
13917:
13918: hr_utility.set_location ('PROCESS COMPLETE!',100);