DBA Data[Home] [Help]

APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_JP_BANK_BRANCHES

Line 99: from pay_jp_bank_branches bch,

95: 'P_SOURCE_BRANCH_NAME_KANA=P', bch.branch_name_kana,
96: 'P_SOURCE_ACCOUNT_TYPE=P', pea.segment7,
97: 'P_SOURCE_ACCOUNT_NUMBER=P', pea.segment8,
98: 'P_SOURCE_ACCOUNT_NAME_KANA=P', pea.segment9
99: from pay_jp_bank_branches bch,
100: pay_jp_banks bnk,
101: pay_external_accounts pea,
102: pay_org_payment_methods_f opm,
103: pay_payroll_actions ppa

Line 155: pay_jp_bank_branches bch,

151: 'P_FULL_NAME=P', min(rpad(pp.per_information18 || ' ' || pp.per_information19,20,' ')),
152: 'P_PAYMENT=P', to_char(sum(ppp.value))
153: from per_all_people_f pp,
154: per_all_assignments_f pa,
155: pay_jp_bank_branches bch,
156: pay_external_accounts pea,
157: pay_personal_payment_methods_f ppm,
158: pay_payroll_actions ppa2, -- Prepay pact
159: pay_assignment_actions paa2, -- Prepay assact