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
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
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
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
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');
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');
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');
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');
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');
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');
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: --
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);
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
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: --
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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: --
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);
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: --
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
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
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
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
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
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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: --
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);
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: --
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
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:
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
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: --
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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');
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:
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:
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);
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);
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
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');
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');
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');
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');
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
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
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: --
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
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
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: --
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: --
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
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: --
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
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: --
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: --
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
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
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:
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);