DBA Data[Home] [Help]

APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on HR_GENERAL_UTILITIES

Line 563: ,nvl(hr_general_utilities.get_lookup_Meaning('KR_BANK',substr(pai.action_information5,1,2)),' ') bank_name

559: CURSOR csr_net_pay(p_assignment_action_id IN NUMBER)
560: IS
561: SELECT pai.action_information_id
562: ,pai.action_information5
563: ,nvl(hr_general_utilities.get_lookup_Meaning('KR_BANK',substr(pai.action_information5,1,2)),' ') bank_name
564: FROM pay_action_information pai
565: WHERE action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
566: AND action_context_id = p_assignment_action_id
567: AND action_context_type = 'AAP';