DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on PER_ALL_ASSIGNMENTS_F

Line 6151: FROM per_all_assignments_f

6147: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
6148: AND bb.SCOPE = 'TIMECARD'
6149: AND bb.resource_type = 'PERSON'
6150: AND bb.resource_id IN(SELECT person_id
6151: FROM per_all_assignments_f
6152: WHERE assignment_type = 'C')
6153: AND pol.po_line_id = x_cascaded_table(n).po_line_id
6154: AND pol.order_type_lookup_code = 'RATE'
6155: AND pol.purchase_basis = 'TEMP LABOR';

Line 14941: FROM per_all_assignments_f

14937: AND bb.object_version_number = x_cascaded_table(n).timecard_ovn
14938: AND bb.SCOPE = 'TIMECARD'
14939: AND bb.resource_type = 'PERSON'
14940: AND bb.resource_id IN(SELECT person_id
14941: FROM per_all_assignments_f
14942: WHERE assignment_type = 'C')
14943: AND pol.po_line_id = x_cascaded_table(n).po_line_id
14944: AND pol.order_type_lookup_code = 'RATE'
14945: AND pol.purchase_basis = 'TEMP LABOR';