APPS.PAY_IN_EFT dependencies on HR_GENERAL

Line 30: , hr_general.decode_lookup('IN_BANK', org_bank_name)

26: , COUNT(*)
27: ,'TOTAL_PAYMENT_AMOUNT=P'
28: , SUM(payment_amt)
29: ,'PAYMENT_BANK_NAME=P'
30: , hr_general.decode_lookup('IN_BANK', org_bank_name)
31: ,'PAYMENT_BANK_BRANCH=P'
32: , hr_general.decode_lookup('IN_BANK_BRANCH', org_bank_branch)
33: ,'PAYMENT_BRANCH_CODE=P'
34: , org_bank_branch

Line 32: , hr_general.decode_lookup('IN_BANK_BRANCH', org_bank_branch)

28: , SUM(payment_amt)
29: ,'PAYMENT_BANK_NAME=P'
30: , hr_general.decode_lookup('IN_BANK', org_bank_name)
31: ,'PAYMENT_BANK_BRANCH=P'
32: , hr_general.decode_lookup('IN_BANK_BRANCH', org_bank_branch)
33: ,'PAYMENT_BRANCH_CODE=P'
34: , org_bank_branch
35: ,'PAYMENT_BANK_ACCOUNT_NUMBER=P'
36: , bank_acc_num

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

115: FROM (SELECT per.employee_number emp_num
116: , SUBSTR(per.full_name,1,80) emp_name1
117: , SUBSTR(per.full_name,81,80) emp_name2
118: , SUBSTR(per.full_name,161,80) emp_name3
119: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
120: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
121: , pea.segment1 emp_acc_num
122: , NVL(ppp.value,0) payment_amt
123: FROM pay_org_payment_methods_f popm

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

116: , SUBSTR(per.full_name,1,80) emp_name1
117: , SUBSTR(per.full_name,81,80) emp_name2
118: , SUBSTR(per.full_name,161,80) emp_name3
119: , hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
120: , hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
121: , pea.segment1 emp_acc_num
122: , NVL(ppp.value,0) payment_amt
123: FROM pay_org_payment_methods_f popm
124: , pay_external_accounts oea