DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on IRC_ASSIGNMENT_STATUSES

Line 2450: FROM irc_assignment_statuses ias3

2446: AND idoc3.type IN ('RESUME','AUTO_RESUME')
2447: AND
2448: (
2449: SELECT min (ias3.status_change_date) + (5 / 86400)
2450: FROM irc_assignment_statuses ias3
2451: WHERE ias3.assignment_id = c_assignment_Id
2452: ) BETWEEN idoc3.creation_date
2453: AND nvl2 (idoc3.end_date
2454: ,idoc3.last_update_date - (5 / 86400)

Line 2466: FROM irc_assignment_statuses ias3

2462: AND idoc3.type IN ('RESUME','AUTO_RESUME')
2463: AND
2464: (
2465: SELECT min (ias3.status_change_date) + (5 / 86400)
2466: FROM irc_assignment_statuses ias3
2467: WHERE ias3.assignment_id = c_assignment_Id
2468: ) BETWEEN idoc3.creation_date
2469: AND nvl2 (idoc3.end_date
2470: ,idoc3.last_update_date - (5 / 86400)