DBA Data[Home] [Help]

APPS.PAY_PAYJPSQD_XMLP_PKG dependencies on HR_GENERAL

Line 98: CP_SI_SEX := hr_general.decode_lookup('JP_SI_SEX',CP_SI_SEX_CODE);

94: CP_FD_COUNT := G_FD_COUNT;
95: CP_BASIC_PENSION_NUMBER := pay_jp_report_pkg.substrb2(pay_jp_balance_pkg.get_entry_value_char(g_basic_pension_number_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE),1,10);
96:
97: CP_SI_SEX_CODE := pay_jp_balance_pkg.get_entry_value_char(g_si_sex_iv_id,ASSIGNMENT_ID,EFFECTIVE_DATE);
98: CP_SI_SEX := hr_general.decode_lookup('JP_SI_SEX',CP_SI_SEX_CODE);
99:
100: l_address_kana := pay_jp_report_pkg.substrb2((pay_jp_report_pkg.set_space_on_address(ADDRESS_KANA1,DISTRICT_NAME_KANA,1)||' '||ADDRESS_KANA2_3),1,240);
101: l_address_kana := replace(replace(l_address_kana,hr_jp_standard_pkg.sjhextochar('8140'),' '),' ',' ');
102: CP_ADDRESS_KANA := l_address_kana;