APPS.PAY_IN_TRX_IDENTIFIERS dependencies on HR_GENERAL

Line 137: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank

133: SELECT per.employee_number emp_num
134: , SUBSTR(per.full_name,1,80) emp_name1
135: , SUBSTR(per.full_name,81,80) emp_name2
136: , SUBSTR(per.full_name,161,80) emp_name3
137: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
138: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
139: , hr_general.decode_lookup('IN_ACCOUNT_TYPE',pea.segment2) emp_acc_name
140: , pea.segment1 emp_acc_num
141: , ppa.legislative_parameters leg_param

Line 138: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch

134: , SUBSTR(per.full_name,1,80) emp_name1
135: , SUBSTR(per.full_name,81,80) emp_name2
136: , SUBSTR(per.full_name,161,80) emp_name3
137: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
138: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
139: , hr_general.decode_lookup('IN_ACCOUNT_TYPE',pea.segment2) emp_acc_name
140: , pea.segment1 emp_acc_num
141: , ppa.legislative_parameters leg_param
142: , SUBSTR(lpad(paa.action_sequence,15,'0'),10) transaction_group

Line 139: , hr_general.decode_lookup('IN_ACCOUNT_TYPE',pea.segment2) emp_acc_name

135: , SUBSTR(per.full_name,81,80) emp_name2
136: , SUBSTR(per.full_name,161,80) emp_name3
137: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
138: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
139: , hr_general.decode_lookup('IN_ACCOUNT_TYPE',pea.segment2) emp_acc_name
140: , pea.segment1 emp_acc_num
141: , ppa.legislative_parameters leg_param
142: , SUBSTR(lpad(paa.action_sequence,15,'0'),10) transaction_group
143: , ppa.request_id request_id