DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on PER_ALL_ASSIGNMENTS_F

Line 5503: FROM per_all_assignments_f

5499: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
5500: AND bb.SCOPE = 'TIMECARD'
5501: AND bb.resource_type = 'PERSON'
5502: AND bb.resource_id IN(SELECT person_id
5503: FROM per_all_assignments_f
5504: WHERE assignment_type = 'C')
5505: AND pol.po_line_id = x_cascaded_table(n).po_line_id
5506: AND pol.order_type_lookup_code = 'RATE'
5507: AND pol.purchase_basis = 'TEMP LABOR';

Line 13555: FROM per_all_assignments_f

13551: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
13552: AND bb.SCOPE = 'TIMECARD'
13553: AND bb.resource_type = 'PERSON'
13554: AND bb.resource_id IN(SELECT person_id
13555: FROM per_all_assignments_f
13556: WHERE assignment_type = 'C')
13557: AND pol.po_line_id = x_cascaded_table(n).po_line_id
13558: AND pol.order_type_lookup_code = 'RATE'
13559: AND pol.purchase_basis = 'TEMP LABOR';