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_SG_IRAS_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 3412: pay_personal_payment_methods_f ppm,

3408: SELECT pea.segment4 bank_name
3409: FROM per_assignments_f assign,
3410: hr_soft_coding_keyflex hsc,
3411: pay_external_accounts pea,
3412: pay_personal_payment_methods_f ppm,
3413: hr_lookups hl
3414: WHERE assign.person_id = c_person_id
3415: AND assign.assignment_id = c_assignment_id
3416: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id

Line 3429: from pay_personal_payment_methods_f ppm1

3425: AND ppm.effective_end_date >= c_basis_start
3426: and priority = 1
3427: and ppm.effective_start_date =
3428: (select max(ppm1.effective_start_date)
3429: from pay_personal_payment_methods_f ppm1
3430: where ppm1.assignment_id = ppm.assignment_id
3431: and ppm1.effective_start_date <= c_basis_end
3432: and ppm1.effective_end_date >= c_basis_start); /* Bug 5868910*/
3433: --