eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_MAGTAPE_GENERIC

Line 73: caused by Oracle when calling pay_magtape_generic.

69: fails with ORA-00979: not GROUP BY expression.
70: 1998/07/30 Toru Tagawa Changed all the cursor for performance tuning.
71: Payment Formulas are also modified.
72: Alter package clause is added in the end to avoid bug
73: caused by Oracle when calling pay_magtape_generic.
74: 1999/07/19 Toshihide Nanjyo Add a semicolon to the exit statement.
75: 2000/02/14 Toru Tagawa Entity change by Bug.1077383 is applied.
76: 2002/06/12 Toru Tagawa All procedures and functions commented out.
77: Package header:

Line 104: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))

100: pay_jp_banks bnk,
101: pay_external_accounts pea,
102: pay_org_payment_methods_f opm,
103: pay_payroll_actions ppa
104: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
105: and opm.org_payment_method_id = ppa.org_payment_method_id
106: and ppa.effective_date
107: between opm.effective_start_date and opm.effective_end_date
108: and pea.external_account_id = opm.external_account_id

Line 126: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))

122: pay_payroll_actions ppa2, -- Prepay pact
123: pay_assignment_actions paa2, -- Prepay assact
124: pay_pre_payments ppp,
125: pay_assignment_actions paa -- Magtape assact
126: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
127: and ppp.pre_payment_id = paa.pre_payment_id
128: and paa2.assignment_action_id = ppp.assignment_action_id
129: and ppa2.payroll_action_id = paa2.payroll_action_id
130: and ppm.personal_payment_method_id = ppp.personal_payment_method_id

Line 162: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))

158: pay_payroll_actions ppa2, -- Prepay pact
159: pay_assignment_actions paa2, -- Prepay assact
160: pay_pre_payments ppp,
161: pay_assignment_actions paa -- Magtape assact
162: where paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
163: and ppp.pre_payment_id = paa.pre_payment_id
164: and paa2.assignment_action_id = ppp.assignment_action_id
165: and ppa2.payroll_action_id = paa2.payroll_action_id
166: and ppm.personal_payment_method_id = ppp.personal_payment_method_id

Line 170: and pea.segment1 = pay_magtape_generic.get_parameter_value('P_DEST_BANK_CODE')

166: and ppm.personal_payment_method_id = ppp.personal_payment_method_id
167: and ppa2.effective_date
168: between ppm.effective_start_date and ppm.effective_end_date
169: and pea.external_account_id = ppm.external_account_id
170: and pea.segment1 = pay_magtape_generic.get_parameter_value('P_DEST_BANK_CODE')
171: and bch.bank_code = pea.segment1
172: and bch.branch_code = pea.segment4
173: and pa.assignment_id = paa.assignment_id
174: and ppa2.effective_date