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

APPS.PAY_JP_REPORT_PKG dependencies on FND_MESSAGE

Line 13: g_husband_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_HUSBAND');

9: g_shouwa_to date := to_date('1989-01-07','YYYY-MM-DD');
10: g_heisei_from date := to_date('1989-01-08','YYYY-MM-DD');
11: g_heisei_to date := g_end_of_time;
12:
13: g_husband_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_HUSBAND');
14: g_wife_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_WIFE');
15: --
16: c_legislation_code varchar2(2) := 'JP';
17: c_com_hi_smr_info_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';

Line 14: g_wife_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_WIFE');

10: g_heisei_from date := to_date('1989-01-08','YYYY-MM-DD');
11: g_heisei_to date := g_end_of_time;
12:
13: g_husband_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_HUSBAND');
14: g_wife_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_WIFE');
15: --
16: c_legislation_code varchar2(2) := 'JP';
17: c_com_hi_smr_info_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';
18: c_com_wp_smr_info_elm pay_element_types_f.element_name%type := 'COM_WP_SMR_INFO';

Line 222: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE'),fnd_message.get_string('PAY','PAY_JP_HUSBAND')),flv1.meaning) CONTACT_TYPE,

218: pcon.per_information18 CON_LAST_NAME,
219: pcon.per_information19 CON_FIRST_NAME,
220: decode(pcon.sex,'M',1,'F',2,3) SEX_ORDER,
221: pcon.date_of_birth DATE_OF_BIRTH,
222: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE'),fnd_message.get_string('PAY','PAY_JP_HUSBAND')),flv1.meaning) CONTACT_TYPE,
223: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE_KANA'),fnd_message.get_string('PAY','PAY_JP_HUSBAND_KANA')),flv2.meaning) CONTACT_TYPE_KANA
224: from
225: hr_lookups flv2,
226: hr_lookups flv1,

Line 223: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE_KANA'),fnd_message.get_string('PAY','PAY_JP_HUSBAND_KANA')),flv2.meaning) CONTACT_TYPE_KANA

219: pcon.per_information19 CON_FIRST_NAME,
220: decode(pcon.sex,'M',1,'F',2,3) SEX_ORDER,
221: pcon.date_of_birth DATE_OF_BIRTH,
222: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE'),fnd_message.get_string('PAY','PAY_JP_HUSBAND')),flv1.meaning) CONTACT_TYPE,
223: decode(pcr.contact_type,'S',decode(pcon.sex,'F',fnd_message.get_string('PAY','PAY_JP_WIFE_KANA'),fnd_message.get_string('PAY','PAY_JP_HUSBAND_KANA')),flv2.meaning) CONTACT_TYPE_KANA
224: from
225: hr_lookups flv2,
226: hr_lookups flv1,
227: per_all_people_f pcon,

Line 975: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');

971: and l_prev_swot_2_rec.prev_swot_si_prem = 0) then
972:
973: if P_KANJI_FLAG = '1' then -- Kanji
974: if (l_description is NULL) then
975: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
976: else
977: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
978: end if;
979: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')

Line 977: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');

973: if P_KANJI_FLAG = '1' then -- Kanji
974: if (l_description is NULL) then
975: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
976: else
977: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
978: end if;
979: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
980: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
981: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

Line 979: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')

975: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
976: else
977: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
978: end if;
979: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
980: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
981: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
982: l_prev_si_prem := ',' ||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
983: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)

Line 981: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

977: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
978: end if;
979: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
980: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
981: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
982: l_prev_si_prem := ',' ||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
983: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
984: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
985: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then

Line 982: l_prev_si_prem := ',' ||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')

978: end if;
979: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
980: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
981: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
982: l_prev_si_prem := ',' ||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
983: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
984: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
985: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
986: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN')

Line 984: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

980: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
981: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
982: l_prev_si_prem := ',' ||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
983: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
984: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
985: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
986: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN')
987: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
988: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX') ||')';

Line 986: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN')

982: l_prev_si_prem := ',' ||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
983: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
984: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
985: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
986: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN')
987: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
988: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX') ||')';
989: end if;
990: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX')

Line 988: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX') ||')';

984: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
985: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
986: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN')
987: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
988: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX') ||')';
989: end if;
990: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX')
991: || to_char(l_prev_swot_2_rec.prev_swot_itax)
992: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

Line 990: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX')

986: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN')
987: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
988: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX') ||')';
989: end if;
990: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX')
991: || to_char(l_prev_swot_2_rec.prev_swot_itax)
992: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
993: if nvl(l_prev_swot_rec.employer_address,' ') <> ' ' then
994: l_prev_add := ',' || l_prev_swot_rec.employer_address;

Line 992: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

988: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX') ||')';
989: end if;
990: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX')
991: || to_char(l_prev_swot_2_rec.prev_swot_itax)
992: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
993: if nvl(l_prev_swot_rec.employer_address,' ') <> ' ' then
994: l_prev_add := ',' || l_prev_swot_rec.employer_address;
995: end if;
996: if nvl(l_prev_swot_rec.employer_name,' ') <> ' ' then

Line 1001: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')

997: l_prev_name := ',' || l_prev_swot_rec.employer_name;
998: end if;
999: if (l_prev_swot_rec.prev_swot_term_date is not NULL) then
1000: l_prev_term := ','
1001: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1002: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1003: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1004: || fnd_message.get_string('PAY','PAY_JP_TERM');
1005: end if;

Line 1002: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')

998: end if;
999: if (l_prev_swot_rec.prev_swot_term_date is not NULL) then
1000: l_prev_term := ','
1001: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1002: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1003: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1004: || fnd_message.get_string('PAY','PAY_JP_TERM');
1005: end if;
1006: else -- Kana

Line 1003: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')

999: if (l_prev_swot_rec.prev_swot_term_date is not NULL) then
1000: l_prev_term := ','
1001: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1002: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1003: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1004: || fnd_message.get_string('PAY','PAY_JP_TERM');
1005: end if;
1006: else -- Kana
1007: if (l_description is NULL) then

Line 1004: || fnd_message.get_string('PAY','PAY_JP_TERM');

1000: l_prev_term := ','
1001: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1002: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1003: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1004: || fnd_message.get_string('PAY','PAY_JP_TERM');
1005: end if;
1006: else -- Kana
1007: if (l_description is NULL) then
1008: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');

Line 1008: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');

1004: || fnd_message.get_string('PAY','PAY_JP_TERM');
1005: end if;
1006: else -- Kana
1007: if (l_description is NULL) then
1008: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1009: else
1010: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1011: end if;
1012: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')

Line 1010: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');

1006: else -- Kana
1007: if (l_description is NULL) then
1008: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1009: else
1010: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1011: end if;
1012: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1013: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
1014: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

Line 1012: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')

1008: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1009: else
1010: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1011: end if;
1012: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1013: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
1014: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1015: l_prev_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1016: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)

Line 1014: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

1010: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1011: end if;
1012: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1013: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
1014: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1015: l_prev_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1016: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
1017: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1018: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then

Line 1015: l_prev_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')

1011: end if;
1012: l_prev_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1013: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
1014: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1015: l_prev_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1016: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
1017: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1018: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
1019: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')

Line 1017: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

1013: || to_char(l_prev_swot_2_rec.prev_swot_taxable_amt)
1014: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1015: l_prev_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1016: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
1017: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1018: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
1019: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1020: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
1021: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') || ')';

Line 1019: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')

1015: l_prev_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1016: || to_char(l_prev_swot_2_rec.prev_swot_si_prem)
1017: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1018: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
1019: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1020: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
1021: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') || ')';
1022: end if;
1023: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')

Line 1021: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') || ')';

1017: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1018: if (l_prev_swot_2_rec.prev_swot_mutual_aid is not NULL) then
1019: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1020: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
1021: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') || ')';
1022: end if;
1023: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')
1024: || to_char(l_prev_swot_2_rec.prev_swot_itax)
1025: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

Line 1023: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')

1019: l_prev_mutual_aid := '(' ||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1020: || to_char(l_prev_swot_2_rec.prev_swot_mutual_aid)
1021: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') || ')';
1022: end if;
1023: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')
1024: || to_char(l_prev_swot_2_rec.prev_swot_itax)
1025: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1026: if nvl(l_prev_swot_rec.employer_address,' ') <> ' ' then
1027: l_prev_add := ',' || l_prev_swot_rec.employer_address;

Line 1025: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

1021: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') || ')';
1022: end if;
1023: l_prev_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')
1024: || to_char(l_prev_swot_2_rec.prev_swot_itax)
1025: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1026: if nvl(l_prev_swot_rec.employer_address,' ') <> ' ' then
1027: l_prev_add := ',' || l_prev_swot_rec.employer_address;
1028: end if;
1029: if nvl(l_prev_swot_rec.employer_name,' ') <> ' ' then

Line 1034: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')

1030: l_prev_name := ',' || l_prev_swot_rec.employer_name;
1031: end if;
1032: if (l_prev_swot_rec.prev_swot_term_date is not NULL) then
1033: l_prev_term := ','
1034: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1035: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1036: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1037: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1038: end if;

Line 1035: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')

1031: end if;
1032: if (l_prev_swot_rec.prev_swot_term_date is not NULL) then
1033: l_prev_term := ','
1034: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1035: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1036: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1037: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1038: end if;
1039: end if;

Line 1036: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')

1032: if (l_prev_swot_rec.prev_swot_term_date is not NULL) then
1033: l_prev_term := ','
1034: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1035: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1036: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1037: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1038: end if;
1039: end if;
1040: l_description := pay_jp_report_pkg.substrb2(l_description

Line 1037: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');

1033: l_prev_term := ','
1034: || lpad(to_char(l_prev_term_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1035: || lpad(to_char(l_prev_term_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1036: || lpad(to_char(l_prev_term_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1037: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1038: end if;
1039: end if;
1040: l_description := pay_jp_report_pkg.substrb2(l_description
1041: || l_prev_taxable_amt || l_prev_si_prem

Line 1191: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');

1187: and l_get_entry_values_rec.pjob_si_prem = 0
1188: and l_get_entry_values_rec.pjob_itax = 0) then
1189: if p_kanji_flag = '1' then
1190: if (l_description is NULL) then
1191: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1192: else
1193: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1194: end if;
1195: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')

Line 1193: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');

1189: if p_kanji_flag = '1' then
1190: if (l_description is NULL) then
1191: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1192: else
1193: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1194: end if;
1195: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
1196: || l_get_entry_values_rec.pjob_taxable_amt
1197: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

Line 1195: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')

1191: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1192: else
1193: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1194: end if;
1195: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
1196: || l_get_entry_values_rec.pjob_taxable_amt
1197: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1198: l_pjob_si_prem := ','||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
1199: || l_get_entry_values_rec.pjob_si_prem

Line 1197: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

1193: l_description := l_description || ',' ||fnd_message.get_string('PAY','PAY_JP_PREVIOUS_EMPLOYMENT');
1194: end if;
1195: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
1196: || l_get_entry_values_rec.pjob_taxable_amt
1197: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1198: l_pjob_si_prem := ','||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
1199: || l_get_entry_values_rec.pjob_si_prem
1200: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1201: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then

Line 1198: l_pjob_si_prem := ','||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')

1194: end if;
1195: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_SALARY')
1196: || l_get_entry_values_rec.pjob_taxable_amt
1197: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1198: l_pjob_si_prem := ','||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
1199: || l_get_entry_values_rec.pjob_si_prem
1200: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1201: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1202: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN')

Line 1200: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

1196: || l_get_entry_values_rec.pjob_taxable_amt
1197: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1198: l_pjob_si_prem := ','||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
1199: || l_get_entry_values_rec.pjob_si_prem
1200: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1201: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1202: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN')
1203: || l_get_entry_values_rec.pjob_mutual_aid
1204: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX')||')';

Line 1202: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN')

1198: l_pjob_si_prem := ','||fnd_message.get_string('PAY','PAY_JP_TRANS_SI')
1199: || l_get_entry_values_rec.pjob_si_prem
1200: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1201: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1202: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN')
1203: || l_get_entry_values_rec.pjob_mutual_aid
1204: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX')||')';
1205: end if;
1206: l_pjob_itax := ','||fnd_message.get_string('PAY','PAY_JP_TAX')

Line 1204: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX')||')';

1200: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1201: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1202: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN')
1203: || l_get_entry_values_rec.pjob_mutual_aid
1204: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX')||')';
1205: end if;
1206: l_pjob_itax := ','||fnd_message.get_string('PAY','PAY_JP_TAX')
1207: || l_get_entry_values_rec.pjob_itax
1208: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

Line 1206: l_pjob_itax := ','||fnd_message.get_string('PAY','PAY_JP_TAX')

1202: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN')
1203: || l_get_entry_values_rec.pjob_mutual_aid
1204: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX')||')';
1205: end if;
1206: l_pjob_itax := ','||fnd_message.get_string('PAY','PAY_JP_TAX')
1207: || l_get_entry_values_rec.pjob_itax
1208: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1209: if nvl(l_get_entry_values_rec.pjob_addr, ' ') <> ' ' then
1210: l_pjob_addr := ',' || l_get_entry_values_rec.pjob_addr;

Line 1208: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');

1204: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX')||')';
1205: end if;
1206: l_pjob_itax := ','||fnd_message.get_string('PAY','PAY_JP_TAX')
1207: || l_get_entry_values_rec.pjob_itax
1208: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX');
1209: if nvl(l_get_entry_values_rec.pjob_addr, ' ') <> ' ' then
1210: l_pjob_addr := ',' || l_get_entry_values_rec.pjob_addr;
1211: end if;
1212: if nvl(l_get_entry_values_rec.pjob_employer_name, ' ') <> ' ' then

Line 1217: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')

1213: l_pjob_employer_name := ',' || l_get_entry_values_rec.pjob_employer_name;
1214: end if;
1215: if (l_get_entry_values_rec.pjob_term_date is not NULL) then
1216: l_pjob_term_date := ','
1217: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1218: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1219: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1220: || fnd_message.get_string('PAY','PAY_JP_TERM');
1221: end if;

Line 1218: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')

1214: end if;
1215: if (l_get_entry_values_rec.pjob_term_date is not NULL) then
1216: l_pjob_term_date := ','
1217: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1218: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1219: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1220: || fnd_message.get_string('PAY','PAY_JP_TERM');
1221: end if;
1222: else

Line 1219: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')

1215: if (l_get_entry_values_rec.pjob_term_date is not NULL) then
1216: l_pjob_term_date := ','
1217: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1218: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1219: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1220: || fnd_message.get_string('PAY','PAY_JP_TERM');
1221: end if;
1222: else
1223: if (l_description is NULL) then

Line 1220: || fnd_message.get_string('PAY','PAY_JP_TERM');

1216: l_pjob_term_date := ','
1217: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PER','HR_JP_YY')
1218: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PER','HR_JP_MM')
1219: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PER','HR_JP_DD')
1220: || fnd_message.get_string('PAY','PAY_JP_TERM');
1221: end if;
1222: else
1223: if (l_description is NULL) then
1224: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');

Line 1224: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');

1220: || fnd_message.get_string('PAY','PAY_JP_TERM');
1221: end if;
1222: else
1223: if (l_description is NULL) then
1224: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1225: else
1226: l_description := l_description || ',' || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1227: end if;
1228: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')

Line 1226: l_description := l_description || ',' || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');

1222: else
1223: if (l_description is NULL) then
1224: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1225: else
1226: l_description := l_description || ',' || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1227: end if;
1228: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1229: || l_get_entry_values_rec.pjob_taxable_amt
1230: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

Line 1228: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')

1224: l_description := l_description || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1225: else
1226: l_description := l_description || ',' || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1227: end if;
1228: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1229: || l_get_entry_values_rec.pjob_taxable_amt
1230: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1231: l_pjob_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1232: || l_get_entry_values_rec.pjob_si_prem

Line 1230: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

1226: l_description := l_description || ',' || fnd_message.get_string('PAY','PAY_JP_PREV_EMPLOYMENT_KANA');
1227: end if;
1228: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1229: || l_get_entry_values_rec.pjob_taxable_amt
1230: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1231: l_pjob_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1232: || l_get_entry_values_rec.pjob_si_prem
1233: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1234: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then

Line 1231: l_pjob_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')

1227: end if;
1228: l_pjob_taxable_amt := fnd_message.get_string('PAY','PAY_JP_TRANS_SALARY_KANA')
1229: || l_get_entry_values_rec.pjob_taxable_amt
1230: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1231: l_pjob_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1232: || l_get_entry_values_rec.pjob_si_prem
1233: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1234: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1235: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')

Line 1233: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

1229: || l_get_entry_values_rec.pjob_taxable_amt
1230: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1231: l_pjob_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1232: || l_get_entry_values_rec.pjob_si_prem
1233: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1234: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1235: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1236: || l_get_entry_values_rec.pjob_mutual_aid
1237: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') ||')';

Line 1235: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')

1231: l_pjob_si_prem := ',' || fnd_message.get_string('PAY','PAY_JP_TRANS_SI_KANA')
1232: || l_get_entry_values_rec.pjob_si_prem
1233: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1234: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1235: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1236: || l_get_entry_values_rec.pjob_mutual_aid
1237: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') ||')';
1238: end if;
1239: l_pjob_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')

Line 1237: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') ||')';

1233: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1234: if (l_get_entry_values_rec.pjob_mutual_aid is not NULL) then
1235: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1236: || l_get_entry_values_rec.pjob_mutual_aid
1237: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') ||')';
1238: end if;
1239: l_pjob_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')
1240: || l_get_entry_values_rec.pjob_itax
1241: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

Line 1239: l_pjob_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')

1235: l_pjob_mutual_aid := '('||fnd_message.get_string('PAY','PAY_JP_WITHIN_KANA')
1236: || l_get_entry_values_rec.pjob_mutual_aid
1237: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') ||')';
1238: end if;
1239: l_pjob_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')
1240: || l_get_entry_values_rec.pjob_itax
1241: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1242: if nvl(l_get_entry_values_rec.pjob_addr, ' ') <> ' ' then
1243: l_pjob_addr := ',' || l_get_entry_values_rec.pjob_addr;

Line 1241: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');

1237: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA') ||')';
1238: end if;
1239: l_pjob_itax := ',' ||fnd_message.get_string('PAY','PAY_JP_TAX_KANA')
1240: || l_get_entry_values_rec.pjob_itax
1241: || fnd_message.get_string('PAY','PAY_JP_JBA_MONEY_SUFFIX_KANA');
1242: if nvl(l_get_entry_values_rec.pjob_addr, ' ') <> ' ' then
1243: l_pjob_addr := ',' || l_get_entry_values_rec.pjob_addr;
1244: end if;
1245: if nvl(l_get_entry_values_rec.pjob_employer_name, ' ') <> ' ' then

Line 1250: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')

1246: l_pjob_employer_name := ',' || l_get_entry_values_rec.pjob_employer_name;
1247: end if;
1248: if (l_get_entry_values_rec.pjob_term_date is not NULL) then
1249: l_pjob_term_date := ','
1250: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1251: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1252: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1253: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1254: end if;

Line 1251: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')

1247: end if;
1248: if (l_get_entry_values_rec.pjob_term_date is not NULL) then
1249: l_pjob_term_date := ','
1250: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1251: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1252: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1253: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1254: end if;
1255: end if;

Line 1252: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')

1248: if (l_get_entry_values_rec.pjob_term_date is not NULL) then
1249: l_pjob_term_date := ','
1250: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1251: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1252: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1253: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1254: end if;
1255: end if;
1256: l_description := pay_jp_report_pkg.substrb2(l_description

Line 1253: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');

1249: l_pjob_term_date := ','
1250: || lpad(to_char(l_year),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_YY_KANA')
1251: || lpad(to_char(l_month),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_MM_KANA')
1252: || lpad(to_char(l_day),2,'0') || fnd_message.get_string('PAY','PAY_JP_TRANS_DD_KANA')
1253: || fnd_message.get_string('PAY','PAY_JP_TRANS_TERM_KANA');
1254: end if;
1255: end if;
1256: l_description := pay_jp_report_pkg.substrb2(l_description
1257: || l_pjob_taxable_amt || l_pjob_si_prem

Line 1402: '20', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY') || ')',

1398: INDEX(PAPF PER_PEOPLE_F_PK) */
1399: DECODE(pceif.cei_information7,
1400: NULL,SUBSTRB(papf.per_information18 || ' ' || papf.per_information19 ||
1401: DECODE(pceif.cei_information6,
1402: '20', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY') || ')',
1403: '30', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER') || ')' , NULL), 1, 2000),
1404: SUBSTRB(papf.per_information18 || ' ' || papf.per_information19 || ' (' || pceif.cei_information7 ||
1405: DECODE(pceif.cei_information6,
1406: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),

Line 1403: '30', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER') || ')' , NULL), 1, 2000),

1399: DECODE(pceif.cei_information7,
1400: NULL,SUBSTRB(papf.per_information18 || ' ' || papf.per_information19 ||
1401: DECODE(pceif.cei_information6,
1402: '20', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY') || ')',
1403: '30', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER') || ')' , NULL), 1, 2000),
1404: SUBSTRB(papf.per_information18 || ' ' || papf.per_information19 || ' (' || pceif.cei_information7 ||
1405: DECODE(pceif.cei_information6,
1406: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),
1407: '30', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER'), NULL) || ')',1,2000)) details

Line 1406: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),

1402: '20', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY') || ')',
1403: '30', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER') || ')' , NULL), 1, 2000),
1404: SUBSTRB(papf.per_information18 || ' ' || papf.per_information19 || ' (' || pceif.cei_information7 ||
1405: DECODE(pceif.cei_information6,
1406: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),
1407: '30', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER'), NULL) || ')',1,2000)) details
1408: FROM per_contact_relationships pcr,
1409: per_contact_extra_info_f pceif,
1410: per_all_people_f papf

Line 1407: '30', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER'), NULL) || ')',1,2000)) details

1403: '30', '(' ||fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER') || ')' , NULL), 1, 2000),
1404: SUBSTRB(papf.per_information18 || ' ' || papf.per_information19 || ' (' || pceif.cei_information7 ||
1405: DECODE(pceif.cei_information6,
1406: '20', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_SEPARATELY'),
1407: '30', ', ' || fnd_message.get_string('PAY','PAY_JP_LIVING_TOGETHER'), NULL) || ')',1,2000)) details
1408: FROM per_contact_relationships pcr,
1409: per_contact_extra_info_f pceif,
1410: per_all_people_f papf
1411: WHERE pcr.person_id = p_person_id