APPS.PAY_IN_TRX_IDENTIFIERS dependencies on HR_ORGANIZATION_INFORMATION

Line 122: l_reg_comp_name hr_organization_information.org_information4%TYPE ;

118: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
119: l_payment_date VARCHAR2(100);
120: l_transaction_group NUMBER(20) ;
121: l_request_id pay_payroll_actions.request_id%TYPE ;
122: l_reg_comp_name hr_organization_information.org_information4%TYPE ;
123: l_bank_acc_num pay_external_accounts.segment1%TYPE ;
124: l_procedure VARCHAR2(100);
125: l_message VARCHAR2(250);
126:

Line 179: FROM hr_organization_information hoi

175:
176: CURSOR csr_reg_comp (l_reg_company NUMBER)
177: IS
178: SELECT hoi.org_information4 company_name
179: FROM hr_organization_information hoi
180: WHERE hoi.organization_id = l_reg_company
181: AND hoi.org_information_context = 'PER_IN_COMPANY_DF' ;
182:
183: