DBA Data[Home] [Help]

APPS.PAY_IN_TRX_IDENTIFIERS dependencies on PAY_EXTERNAL_ACCOUNTS

Line 116: l_emp_acc_num pay_external_accounts.segment1%TYPE ;

112: l_emp_name3 per_people_f.full_name%TYPE ;
113: l_emp_bank hr_lookups.meaning%TYPE ;
114: l_emp_branch hr_lookups.meaning%TYPE ;
115: l_emp_acc_name hr_lookups.meaning%TYPE ;
116: l_emp_acc_num pay_external_accounts.segment1%TYPE ;
117: l_reg_comp pay_external_accounts.segment1%TYPE ;
118: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
119: l_payment_date VARCHAR2(100);
120: l_transaction_group NUMBER(20) ;

Line 117: l_reg_comp pay_external_accounts.segment1%TYPE ;

113: l_emp_bank hr_lookups.meaning%TYPE ;
114: l_emp_branch hr_lookups.meaning%TYPE ;
115: l_emp_acc_name hr_lookups.meaning%TYPE ;
116: l_emp_acc_num pay_external_accounts.segment1%TYPE ;
117: l_reg_comp pay_external_accounts.segment1%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 ;

Line 123: l_bank_acc_num pay_external_accounts.segment1%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:
127:

Line 146: , pay_external_accounts oea

142: , SUBSTR(lpad(paa.action_sequence,15,'0'),10) transaction_group
143: , ppa.request_id request_id
144: ,oea.segment1 bank_acc_num
145: FROM pay_org_payment_methods_f popm
146: , pay_external_accounts oea
147: , pay_personal_payment_methods_f pppm
148: , pay_external_accounts pea
149: , pay_pre_payments ppp
150: , pay_assignment_actions paa

Line 148: , pay_external_accounts pea

144: ,oea.segment1 bank_acc_num
145: FROM pay_org_payment_methods_f popm
146: , pay_external_accounts oea
147: , pay_personal_payment_methods_f pppm
148: , pay_external_accounts pea
149: , pay_pre_payments ppp
150: , pay_assignment_actions paa
151: , pay_payroll_actions ppa
152: , per_assignments_f asg