DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 3541: pay_personal_payment_methods_f ppm,

3537: SELECT pea.segment4 bank_name
3538: FROM per_assignments_f assign,
3539: hr_soft_coding_keyflex hsc,
3540: pay_external_accounts pea,
3541: pay_personal_payment_methods_f ppm,
3542: hr_lookups hl
3543: WHERE assign.person_id = c_person_id
3544: AND assign.assignment_id = c_assignment_id
3545: AND assign.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id

Line 3558: from pay_personal_payment_methods_f ppm1

3554: AND ppm.effective_end_date >= c_basis_start
3555: and priority = 1
3556: and ppm.effective_start_date =
3557: (select max(ppm1.effective_start_date)
3558: from pay_personal_payment_methods_f ppm1
3559: where ppm1.assignment_id = ppm.assignment_id
3560: and ppm1.effective_start_date <= c_basis_end
3561: and ppm1.effective_end_date >= c_basis_start); /* Bug 5868910*/
3562: --