DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on HR_GENERAL

Line 345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);

341: --
342: -- Get the translated names of input values from NAME Translations lookup
343: --
344: hr_utility.set_location('Loading translated names ' || l_proc, 50);
345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);
346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);

Line 346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);

342: -- Get the translated names of input values from NAME Translations lookup
343: --
344: hr_utility.set_location('Loading translated names ' || l_proc, 50);
345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);
346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);
350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);

Line 347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);

343: --
344: hr_utility.set_location('Loading translated names ' || l_proc, 50);
345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);
346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);
350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);
351: --

Line 348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);

344: hr_utility.set_location('Loading translated names ' || l_proc, 50);
345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);
346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);
350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);
351: --
352: -- Get the context id of SOURCE_TEXT in ff_contexts

Line 349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);

345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);
346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);
350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);
351: --
352: -- Get the context id of SOURCE_TEXT in ff_contexts
353: --

Line 350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);

346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);
349: g_fr_name_start_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','START_DATE'), g_fr_name_start_date);
350: g_fr_name_end_date := nvl(hr_general.decode_lookup('NAME_TRANSLATIONS','END_DATE'), g_fr_name_end_date);
351: --
352: -- Get the context id of SOURCE_TEXT in ff_contexts
353: --
354: open csr_context('SOURCE_TEXT');

Line 871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);

867: -- Load the TOTALS bolierplate text
868: --
869: hr_utility.set_location('Entering ' || l_proc || 'loading totals names', 10);
870: --
871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);
872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);

Line 872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);

868: --
869: hr_utility.set_location('Entering ' || l_proc || 'loading totals names', 10);
870: --
871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);
872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);

Line 873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);

869: hr_utility.set_location('Entering ' || l_proc || 'loading totals names', 10);
870: --
871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);
872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);

Line 874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);

870: --
871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);
872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);

Line 875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);

871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);
872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);
879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);

Line 876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);

872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);
879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);
880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);

Line 877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);

873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);
874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);
879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);
880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);
881: --

Line 878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);

874: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c4_taxable_income);
875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);
879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);
880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);
881: --
882: -- Archive the bolilerplate to the running totals

Line 879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);

875: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c5_total_charges);
876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);
879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);
880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);
881: --
882: -- Archive the bolilerplate to the running totals
883: --

Line 880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);

876: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c6_net_salary);
877: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c7_total_pay);
878: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c8_previous_advice);
879: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c9_this_advice);
880: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c10_net_advice);
881: --
882: -- Archive the bolilerplate to the running totals
883: --
884: pay_action_information_api.create_action_information(

Line 907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);

903: -- Load balance names
904: --
905: hr_utility.set_location('Entering ' || l_proc || 'loading balance names', 20);
906: --
907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);
908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);

Line 908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);

904: --
905: hr_utility.set_location('Entering ' || l_proc || 'loading balance names', 20);
906: --
907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);
908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);

Line 909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);

905: hr_utility.set_location('Entering ' || l_proc || 'loading balance names', 20);
906: --
907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);
908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);

Line 910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);

906: --
907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);
908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);

Line 911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);

907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);
908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);

Line 912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);

908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);

Line 913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);

909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);
910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);
917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);

Line 914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);

910: l_text4 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c4_stat_er_charges);
911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);
917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);
918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);

Line 915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);

911: l_text5 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c5_conv_er_charges);
912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);
917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);
918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);
919: --

Line 916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);

912: l_text6 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c6_t1_arrco);
913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);
917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);
918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);
919: --
920: -- Archive the bolilerplate to the Balances

Line 917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);

913: l_text7 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c7_t2_arrco);
914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);
917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);
918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);
919: --
920: -- Archive the bolilerplate to the Balances
921: --

Line 918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);

914: l_text8 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c8_tb_agirc);
915: l_text9 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c9_tc_agirc);
916: l_text10 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c10_gmp);
917: l_text11 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c11_total_er_cost);
918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);
919: --
920: -- Archive the bolilerplate to the Balances
921: --
922: hr_utility.set_location('Entering ' || l_proc || 'archiving balance names', 30);

Line 1455: ,hr_general.decode_lookup('LEAV_REAS', svc.leaving_reason)

1451: --
1452: cursor csr_get_service_dates (p_assignment_id number, p_effective_date date) is
1453: select svc.actual_termination_date ATD
1454: ,nvl(svc.adjusted_svc_date, svc.date_start)
1455: ,hr_general.decode_lookup('LEAV_REAS', svc.leaving_reason)
1456: ,svc.pds_information11 final_pay_schedule
1457: ,fnd_date.canonical_to_date(svc.pds_information10) LWD
1458: from per_periods_of_service svc
1459: ,per_all_assignments_f asg