DBA Data[Home] [Help]

APPS.PAY_PRG_PROCESS_EVENTS dependencies on PAY_RECORDED_REQUESTS

Line 478: from pay_recorded_requests prr

474: where ppe.creation_date < fnd_date.canonical_to_date(p_purge_date)
475: and ppe.assignment_id between x_start_id and x_end_id
476: and (not exists
477: (select 1
478: from pay_recorded_requests prr
479: where prr.attribute1 = ppe.assignment_id
480: and prr.attribute_category = 'RETRONOT_ASG')
481: or ppe.creation_date < (select prr.recorded_date
482: from pay_recorded_requests prr

Line 482: from pay_recorded_requests prr

478: from pay_recorded_requests prr
479: where prr.attribute1 = ppe.assignment_id
480: and prr.attribute_category = 'RETRONOT_ASG')
481: or ppe.creation_date < (select prr.recorded_date
482: from pay_recorded_requests prr
483: where prr.attribute1 = ppe.assignment_id
484: and prr.attribute_category = 'RETRONOT_ASG'));
485:
486: BEGIN