DBA Data[Home] [Help]

APPS.PAY_FI_EFT dependencies on HR_SOFT_CODING_KEYFLEX

Line 35: SELECT /*+ INDEX( hsck , HR_SOFT_CODING_KEYFLEX_PK) */ 'PAYER_CODE=P',hoi2.org_information1

31: /********************************************************
32: * Cursor to fetch Body record information *
33: ********************************************************/
34: CURSOR CSR_FI_EFT_BODY IS
35: SELECT /*+ INDEX( hsck , HR_SOFT_CODING_KEYFLEX_PK) */ 'PAYER_CODE=P',hoi2.org_information1
36: ,'PAY_DATE=P',to_char(fnd_date.canonical_to_date(pay_fi_eft.get_parameter
37: (ppa.legislative_parameters,'PROCESS_DATE')),'YYYYMMDD')
38: ,'PAYER_NAME=P',substr(o1.name,1,16)
39: ,'PAYER_INFO=P',lpad(nvl(pay_fi_eft.get_parameter(ppa.legislative_parameters,'PAYER_INFO'),' '),10,' ')

Line 62: ,hr_soft_coding_keyflex hsck

58: ,pay_pre_payments ppp
59: ,pay_personal_payment_methods_f pppm
60: ,per_all_people_f pef
61: ,pay_external_accounts pea
62: ,hr_soft_coding_keyflex hsck
63: ,hr_all_organization_units o1
64: ,hr_organization_information hoi1
65: ,hr_organization_information hoi2
66: ,hr_organization_information hoi3